topic Re: Date time conversion in QlikView

Date time conversion

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

Hi All,

My data base is returning time in this format

can anyone help me to convert this into day ,hours(24hrs format),min parts as individual fields.

aniruddhyadutta — Fri, 21 Oct 2016 07:29:16 GMT

Hi,

greetings for the day to all!!

can anyone help me on this issue?

Thanks

Aniruddhya

Miguel_Angel_Baeyens — Fri, 21 Oct 2016 08:22:25 GMT

Hi Aniruddhya,

I'm using the Date() function and templates from memory but it should be very similar to this:

Date(Date#(Field, 'DD-MMM-YY hh.mm.ss.fffffffff TT')) AS Date

Miguel

Anonymous — Fri, 21 Oct 2016 08:41:09 GMT

Hi,

Please check the below code,

DateTbl:

Load * Inline [

TempDate

01-Oct-16 01.00.13.000000440PM

];

NoConcatenate

DateFormatTbl:

LOAD Date(Date#('01-Oct-16 01.00.13.000000440 PM', 'DD-MMM-YY hh.mm.ss.fffffffff TT'),'M/D/YYYY h:mm:ss[.fff]') as TempDate

Resident DateTbl;

DROP Table DateTbl;

Calendar:

LOAD Date(TempDate) as SampleDate,

Month(TempDate) as SampleMonth,

Year(TempDate) as SampleYear,

Hour(TempDate) as SampleHour,

Minute(TempDate) as SampleMinute

Resident DateFormatTbl;

DROP Table DateFormatTbl;

Regards,

Leni Balakrishnan

aniruddhyadutta — Mon, 24 Oct 2016 09:49:10 GMT

Thanks a lot it worked!!

aniruddhyadutta — Mon, 24 Oct 2016 09:49:48 GMT

Hi leni,

Thanks for your detailed reply.the format you mentioned also worked for me..:)