topic Re: Time format in QlikView

Time format

Mon, 26 Jan 2026 18:19:17 GMT

hi all,

In my application having an filed CDT with datetime format.

Now i needs to have new field only with hours and minutes.

Ex: My CDT with DateTime format will look like below

CDT

01/01/2013 00:00:15

01/01/2013 00:01:00

01/01/2013 00:50:00

01/01/2013 01:01:00

01/01/2013 13:05:00

01/01/2013 23:50:00

Now i want new field only with Hour ans Minutes as below for above example

NewCDT

101

1305

2350

Please can anyone let me know how to do this.

Thanks in advance.

Re: Time format

sreenivas — Fri, 08 Feb 2013 11:08:59 GMT

PFA

Re: Time format

jagannalla — Fri, 08 Feb 2013 11:24:40 GMT

Try this

Num(Num#(Text(Timestamp(CDT,'hmm'))))

Hope it helps you..

Re: Time format

Fri, 08 Feb 2013 11:29:50 GMT

try this

LOAD *

INLINE [

CDT

01/01/2013 00:00:15

01/01/2013 00:01:00

01/01/2013 00:50:00

01/01/2013 01:01:00

01/01/2013 13:05:00

01/01/2013 23:50:00

];

LOAD *, Date(Date#(CDT,'MM/DD/YYYY hh:mm:ss'),'hhmm') as newCDT

Resident A;

then output like this

newCDT

101

1305

2350

Re: Time format

Sat, 09 Feb 2013 01:59:50 GMT

Hi. You can also use

Hour(Date#(CDT,'DD/MM/YYYY hh:mm:ss')) as Hours,

Minute(Date#(CDT,'DD/MM/YYYY hh:mm:ss')) as Minute,

Hour(Date#(CDT,'DD/MM/YYYY hh:mm:ss')) & ':' & minute(Date#(CDT,'DD/MM/YYYY hh:mm:ss')) as HM

Alessandro Furtado