topic Re: Timestamp Issue in QlikView

Timestamp Issue

Mon, 26 Oct 2015 07:28:23 GMT

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

Re: Timestamp Issue

PradeepReddy — Mon, 26 Oct 2015 07:48:02 GMT

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')

Re: Timestamp Issue

sasiparupudi1 — Mon, 26 Oct 2015 07:55:47 GMT

Try

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

Re: Timestamp Issue

jsingh71 — Mon, 26 Oct 2015 08:10:37 GMT

Try this also:

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

Re: Timestamp Issue

jagan — Mon, 26 Oct 2015 09:28:37 GMT

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.