TIMESTAMP

deepthi · Post by **deepthi** » Thu Sep 08, 2005 11:54 am

Hi,
i'm trying to convert a "datasetyr" columns datatype from varchar to timestamp as my source datatype is varchar and output datatype for that column is timestamp.
in modify stage i used the syntax:
conv_datasetyr:Timestamp = Timestamp_from_Varchar(datasetyr)
please help me with this.
thank you
deepthi

Mat01 · Post by **Mat01** » Thu Sep 08, 2005 12:10 pm

Hi,

Try this one: timestamp_from_string[timestamp_format](string)

Converts the string to a timestamp
representation
using the specified timestamp_format.

By default, the string format
is %yyyy-%mm-%dd
hh:nn:ss.

HTH

Mat

deepthi · Post by **deepthi** » Thu Sep 08, 2005 2:32 pm

Hi Mat01,
i'm still getting the syntax error

ray.wurlod · Post by **ray.wurlod** » Thu Sep 08, 2005 4:14 pm

Please post the exact error message.