Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
Try
=Timestamp(Timestamp#(left('09/21/2015 00:59:30 AM',19),'MM/DD/YYYY hh:mm:ss'),'MM/DD/YYYY hh:mm:ss')
Try this also:
=Replace('09/21/2015 00:59:30 AM',Right('09/21/2015 00:59:30 AM',3),'')
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.