topic Re: Timestamp not working in QlikView

Timestamp not working

Fri, 20 Nov 2020 18:02:30 GMT

So here is what happens,

Initial Data format

2010-12-05T00:30:00-05:00 so YYYY-MM-DDTHH:MM:SS-AA:BB

here is the code that I used

Timestamp#(left(replace(StartAt, 'T', ' '),19), 'YYYY-MM-DDhh:mm:ss.fff') as MyTimeStamp,

^^ this works as I can see expected result in list box

and then when I do (all of them do not work)

=Hour(MyTimeStamp)

=Floor(MyTimeStamp)

in expression for the title, or even in the load statement,I do not get the expected result !

Please help !

Thank you.

MayilVahanan — Mon, 21 Oct 2013 16:15:56 GMT

Try like this

TimeStamp(Timestamp#(left(replace(StartAt, 'T', ' '),19), 'YYYY-MM-DDhh:mm:ss.fff') ,'YYYY-MM-DDhh:mm:ss.fff') AS MyTimeStamp;

CELAMBARASAN — Mon, 21 Oct 2013 16:21:25 GMT

You should use Timestamp function around the TimeStamp#

TimeStamp(Timestamp#(StartAt 'YYYY-MM-DDThh:mm:ss.fff') ,'YYYY-MM-DDhh:mm:ss.fff') AS MyTimeStamp;

if your splitting for some other string the use Left(StartAt, 20) in the place of StartAt

Mon, 21 Oct 2013 16:21:44 GMT

Now nothing is working ! the listbox doesn't show dates any more for the field MyTimeStamp

Mon, 21 Oct 2013 16:25:42 GMT

As suggested above,

this code worked for me :

TimeStamp(Timestamp#(left(replace(StartAt, 'T', ' '),19), 'YYYY-MM-DD hh:mm:ss[.fff]') ,'YYYY-MM-DD hh:mm:ss[.fff]') AS MyTimeStamp

Thank you for your help.