topic Re: Time Stamp to Time in QlikView

Time Stamp to Time

Fri, 08 Feb 2013 05:11:46 GMT

Good Day i have Problem with this TimeStamp that i would like it to converted into time.

Sample:

2012-10-16 09:21:01 the output must be 9:21

But in time

time(left(right(time,8),5),'HH:MM') as Time output is 00:12?

can somebody give me idea?

Thank you,

Re: Time Stamp to Time

Oleg_Troyansky — Fri, 08 Feb 2013 05:35:23 GMT

first, you need to convert your string to a timestamp, and then format it any way you want. The syntax should be something like this:

timestamp(

timestamp#(MyTime, 'YYYY-MM-DD hh:mm:ss')

, 'hh:mm')

notice that the hours, minutes and seconds are represented by the lower case letters : hh:mm:ss, in contrast to YYYY-MM-DD

cheers,

Oleg Troyansky

Re: Time Stamp to Time

Fri, 08 Feb 2013 05:43:09 GMT

timestamp(timestamp#(timelogs, 'YYYY-MM-DD hh:mm:ss'),'hh:mm') as Time no Output
and i tried this one
time(timestamp#(timelogs, 'YYYY-MM-DD hh:mm:ss'),'hh:mm') as Time no Output too.

Thank you for your Response

Re: Time Stamp to Time

Fri, 08 Feb 2013 06:26:42 GMT

U can use the below expression.

=timestamp(Timestamp('2012-10-16 09:21:01', 'YYYY--MM-DD HH:MM:SS'),'h:mm')

~Kabilan K.

Re: Time Stamp to Time

Fri, 08 Feb 2013 06:44:40 GMT

Got it Thank you.

Re: Time Stamp to Time

praveenak — Fri, 03 Apr 2015 17:11:46 GMT

Hi,

I think u can use the below exp.

=time('2012-10-16 09:21:01','h:mm')

Re: Time Stamp to Time

Koniki — Sun, 28 Jul 2019 15:01:05 GMT

=time('2019-07-28 09:21:01','h:mm')