Hi All,
I have a date field from the input and it's value is 1997-10-20 16:36:51 and type is Varchar(19).
Iam trying to load it to a db2 table and the SQL type is TimeStamp(19).
I have done the following conversion:
StringToTimestamp(<Field_Nmae>,"%yyyy-%mm-%dd %hh:%nn:%ss")
Iam getting the following error message.
APT_CombinedOperatorController,6: Conversion error calling conversion routine timestamp_from_string data may have been lost
Please advise.
Regards
Cherry
Conversion error - TimeStamp_From_String
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
There is a difference Arnd. You just haven't noticed it. There is an extra "(" in the later post which makes it incorrect.
It can happen in a lot of cases where
format picture is inconsistant
column length
unwanted characters (extra spaces, but if you are sure its varchar(19) through out check for different formats you are getting)
Unicode to ascii conversion(generally has other warning message too)?
Do as Arnd suggested and let us know the results.
![Wink :wink:](./images/smilies/icon_wink.gif)
It can happen in a lot of cases where
format picture is inconsistant
column length
unwanted characters (extra spaces, but if you are sure its varchar(19) through out check for different formats you are getting)
Unicode to ascii conversion(generally has other warning message too)?
Do as Arnd suggested and let us know the results.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.![Wink :wink:](./images/smilies/icon_wink.gif)
Genius may have its limitations, but stupidity is not thus handicapped.
![Wink :wink:](./images/smilies/icon_wink.gif)