Timestamp Issue

[#1]

Hi All, I am facing issue in conversion of timestamp and format of the time stamp is '09/21/2015 00:59:30 AM' I m using this expression Timestamp(Timestamp#('09/21/2015 00:59:30 AM','MM/DD/YYYY hh:mm:ss tt'),'MM/DD/YYYY hh:mm:ss') and getting ouput as null. Please help me out. Regards Deepak

[PradeepReddy]

just try once..

Timestamp(Timestamp#('09/21/2015 12:59:30 AM','MM/DD/YYYY hh:mm:ss tt'),'MM/DD/YYYY hh:mm:ss')

[sasiparupudi1]

Try

=Timestamp(Timestamp#(left('09/21/2015 00:59:30 AM',19),'MM/DD/YYYY hh:mm:ss'),'MM/DD/YYYY hh:mm:ss')

[jsingh71]

Try this also:

=Replace('09/21/2015 00:59:30 AM',Right('09/21/2015 00:59:30 AM',3),'')

[jagan]

Hi Deepak,

00:59:30 AM is an invalid time, the valid time 12:59:30 AM.

=Timestamp(Timestamp#('09/21/2015 12:59:30 AM', 'MM/DD/YYYY hh:mm:ss tt'))  -- Valid

The other option is truncate AM/PM in timestamp and convert to DateTime like below

=Timestamp(Timestamp#(left('09/21/2015 00:59:30 AM',19),'MM/DD/YYYY hh:mm:ss'),'MM/DD/YYYY hh:mm:ss')

Hope this helps you.

Regards,

Jagan.