topic Get only time from a Data Time string in QlikView

Get only time from a Data Time string

MK9885 — Sat, 16 Nov 2024 17:43:36 GMT

Hi,

How can I get only time from below field?

I just want 11:35 or 12:25 etc
I used Time# and other functions but doesn't work.. maybe because this string has YYYY-MM-DD HH:MM:SS and then some 000000...
Those 0000's in the end doesn't give me correct time. I just get time as 00:00.

Re: Get only time from a Data Time string

PriyankaShivhare — Wed, 09 Dec 2020 02:44:43 GMT

Time(Frac(DateTimeField),'hh:mm')

Re: Get only time from a Data Time string

MayilVahanan — Wed, 09 Dec 2020 03:09:19 GMT

Hi @MK9885

I think, your field in string format, try like below

=mid('2020-10-12 11:35:00.0000', 12, 5)

Mid(urtimestampfield, 12, 5)

Re: Get only time from a Data Time string

MK9885 — Wed, 09 Dec 2020 16:25:41 GMT

Thanks Mayi
Mid(urtimestampfield, 12, 5) << worked