Error in timestamp_from_string function in Modify stage

[chandrayadaraju]

Hi All,

I am using the timestamp_from_string function in Modify stage. The Specification is as below

SRC_CREATE_DTTM:timestamp=timestamp_from_string[%yyyy-%mm-%dd hh:nn:ss](SRC_CREATE_DTTM)

The Function is returning the output in timestamp format but removing the time portion of the string and putting 00:00:00.

Input is (string): 2009-05-29 10:16:38
Output is(timestamp): 2009-05-29 00:00:00

I am just curious whether anyone is aware of this issue and know the solution. If so, Please reply.

I appreciate your suggestions to this.


Thanks
Chandra

[us1aslam1us]

Nothing wrong here but change [%yyyy-%mm-%dd hh:nn:ss] to [%yyyy-%mm-%dd %hh:%nn:%ss] and try it.