topic Datetime to just time in QlikView

Datetime to just time

Fri, 18 Mar 2011 07:19:03 GMT

Hi guys...

I need to extract just time from a field which is DateTimestamp.... But i can't think of anything... The format is as follows:

'DD/MM/YYYY hh:mm:ss'

i have tried

time(DATETIME) as TransTime

time(DATETIME, 'hh:mm') as TransTime

But neither are working. Any suggestions please?

Regards

Fri, 18 Mar 2011 07:37:13 GMT

Hi,

What are the output of the two functions you are trying ?

You can use timestamp() function or maketime function.

if all the date-time values are having proper length at least for time part then maketime will work.

use maketime ( mid ( date, 12, 2 ), mid ( date, 16, 2 ), right ( date, 2 ) ) as time

Reg,

Shubhu

Fri, 18 Mar 2011 07:38:18 GMT

Dear

try it

=time(date(DATETIME,'DD/MM/YYYY hh:mm:ss'),'hh:mm')

it should be work. and above function is also working.

I tried both functions are working properly.

Thanks and Regards

Fri, 18 Mar 2011 13:01:46 GMT

Hi Blaze,

Try this...

TIME

(NOW(),'hh:mm:ss:TT')

Miguel_Angel_Baeyens — Fri, 18 Mar 2011 13:10:03 GMT

Hello,

First, get the right timestamp, then get the time part of it

=Time(TimeStamp#('08/03/2011 08:10:30', 'DD/MM/YYYY hh:mm:ss'))

Hope that helps.