Hi
I have arequirement to convert MMM DD YYYY HH:MM:SS AM orPM
to mm/dd/yyyy HH:MM:SS
I cant use a basic transformer for ICONV and OCONV
I am trying to use string to timestamp fn but its not working out.
Any suggestions
Thanks
Last edited by mab_arif16 on Tue May 16, 2006 11:27 am, edited 1 time in total.
mab_arif16 wrote:Hi
I have arequirement to convert MMM DD YYYY HH:MM:SS AM orPM
to mm/dd/yyyy HH:MM:SS
I cant use a basic transformer for ICONV and OCONV
I am trying to use string to timestamp fn but its not working out.
ARif
Can you tell us what is the exact function you are using and what exactly is the error,so that someone could help you.
I am trying to use it in modify stage.
Date4:Timestamp=StringToTimestamp(Date1)
The error is
main_program: Error parsing modify adapter: Error in binding: Unknown conversion: StringToTimestamp
Expected destination field selector, got: ")"; input:
Date4:Timestamp=StringToTimestamp(Date1)
Thats the same thing I tried
Does something need to be changed here before the equation and can this be used in modify stage
Date4:Timestamp=StringToTimestamp(Date1)
Thanks
Arif
Hi all
I need to convert MM/DD/YYYY HH:MM:SS AM or PM to DB2 Timestamp.
Is there any function available to do this.
I really appreciate any suggestions on this.