converting am to hours

[mab_arif16]

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

[us1aslam1us]

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.

Thanks
Sam

[mab_arif16]

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)

[us1aslam1us]

viewtopic.php?t=100535&highlight=date4+timestamp

Thanks
Sam

[mab_arif16]

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

[ray.wurlod]

Why can't you use a BASIC Transformer? It's there, it's part of your tool kit.

[Sathish]

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.

I'm on Windows Server Edition 7.5x2

Thanks
Sathish

[ray.wurlod]

Etiquette Note
We do not hijack threads. Please start a new thread with your new question.