topic Re: Extract time from date time field in QlikView

Extract time from date time field

Thu, 17 Jul 2014 12:24:24 GMT

I need to extract only the time from a date/time field. Either in the load script (ODBF to informix) to in the properties of the list box. I an trying to group time ranges regardless of the date.

Re: Extract time from date time field

ashfaq_haseeb — Thu, 17 Jul 2014 12:28:13 GMT

HI,

Try

time(yourdatefield) as Time,

Regards

ASHFAQ

Re: Extract time from date time field

Thu, 17 Jul 2014 12:31:14 GMT

That would work at the list level, but the list still sorts by date first even though only the time is diaplayed. I am trying to group and sort by time only regardless of the date. Probably need to get time extracted at the script level ??

Re: Extract time from date time field

Thu, 17 Jul 2014 12:54:09 GMT

In the Script Load, you can try to create a new time field:

LOAD

Time(YourDateField) as YourTimeField

...

From...

Re: Extract time from date time field

tresB — Thu, 17 Jul 2014 12:54:52 GMT

Time() is a formatting function, hence it doesn't change the underlaying number but the format only. To get the time part only use Frac(), like:

time(frac(yourdatefield)) as Time,

Re: Extract time from date time field

MK_QSL — Thu, 17 Jul 2014 12:58:02 GMT

=TIME(FRAC(Timestamp#('17/07/2014 10:30:00','DD/MM/YYYY hh:mm:ss')))

Replace '17/07/2014 10:30:00' with your Date/Time Field

Also, change the DD/MM/YYYY hh:mm:ss according to your timestamp format