DSXchange

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

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

Hi Mat01,
i'm still getting the syntax error

Please post the exact error message.