Error in timestamp_from_string function in Modify stage
Posted: Fri May 29, 2009 2:21 pm
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
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