topic Re: Time from Datetime in QlikView

Time from Datetime

haymarketpaul — Wed, 25 Nov 2020 16:16:04 GMT

QV12 SR3

I have the following Datetime field

MyDatetime	Date	Time
10/01/2011 12:02:07	10/01/2011	12:02

I want to extract the Date and Time from it but i only want the hh:mm part of the time (like above)

I can get the date with this...

Date(Floor(MyDatetime))

i thought this might help me get the time portion i need but i'm missing something somewhere...

Time(Time#(Frac(MyDatetime),'hh:mm:ss'),'hh:mm')

Re: Time from Datetime

sdmech81 — Thu, 09 Feb 2017 11:53:08 GMT

check with :

=Timestamp(MyDatetime)

Re: Time from Datetime

surendraj — Thu, 09 Feb 2017 11:54:39 GMT

date(date#('10/01/2011 12:02:07','DD/MM/YYYY hh:mm:ss'),'DD-MM-YYYY') as Date,

Timestamp(date#('10/01/2011 12:02:07','DD/MM/YYYY hh:mm:ss'),'hh:mm') as Time

Re: Time from Datetime

sunny_talwar — Thu, 09 Feb 2017 11:55:20 GMT

May be this:

Time(Round(Frac(MyDateTime), (1/24*60))) as Time

Time(Floor(Frac(MyDateTime), (1/24*60))) as Time

Re: Time from Datetime

sdmech81 — Thu, 09 Feb 2017 11:55:40 GMT

use like this:

=Timestamp(MyDatetime,'hh:mm')

Re: Time from Datetime

sdmech81 — Thu, 09 Feb 2017 11:58:10 GMT

Only this much should work bcs your MyDatetimeis proper format I guess

Thanks

Re: Time from Datetime

haymarketpaul — Thu, 09 Feb 2017 12:03:52 GMT

Thanks all

Timestamp(MyDatetime,'hh:mm') works nicely

the others didn't seem to quite work but interesting

Re: Time from Datetime

sdmech81 — Thu, 09 Feb 2017 12:09:52 GMT

The simple wat to check wthr u can go ahead and use Date and time functions bfr jumping into string fns,any function on dates is to add the date column in to list box then check if the values r falling on right side of list box then Qlik has taken it as date,if values fall on left side of list box then Qlik didn't.

Plss check HIC docs on date.Thanks