topic Re: timestamp format in QlikView

timestamp format

Anonymous — Tue, 15 Sep 2015 17:54:10 GMT

Hi guys,

How can I get a date in format YYYY-MM-DD h:mm:ss TT?

=If(Auto_Id=1519,Timestamp((num(date#(TimeStamp, 'YYYY-MM-DD h:mm:ss[.fff] TT'))-0.0417)), 'YYYY-MM-DD h:mm:ss[.fff] TT')

I got in result 9/13/2015 2:40:49 AM

Thanks,

MK_QSL — Tue, 15 Sep 2015 18:00:45 GMT

What is the format of your TimeStamp field?

Anonymous — Tue, 15 Sep 2015 18:02:06 GMT

'2015-09-13 3:42:09 AM'

Anonymous — Tue, 15 Sep 2015 18:03:28 GMT

I got it

Timestamp((num(date#(TimeStamp, 'YYYY-MM-DD h:mm:ss[.fff] TT'))-0.0417),'YYYY-MM-DD hh:mm:ss TT' )

just remove .[fff]

MK_QSL — Tue, 15 Sep 2015 18:05:19 GMT

=TimeStamp(TimeStamp# ('2015-09-13 3:42:09 AM','YYYY-MM-DD h:mm:ss TT')-0.0417,'YYYY-MM-DD h:mm:ss TT')

maxgro — Tue, 15 Sep 2015 18:11:02 GMT

replace '9/13/2015 2:40:49 AM' with your field

=Timestamp(Timestamp#('9/13/2015 2:40:49 AM', 'MM/DD/YYYY hh:mm:ss TT'), 'YYYY-MM-DD h:mm:ss TT')

the bold part is from text to num (interpretation function, Timestamp#)

the non bold part is from num to text (formatting function (Timestamp)

more here