topic Re: Date Format in QlikView

Date Format

Wed, 27 May 2015 10:12:37 GMT

How to convert date format in oracle query.

vishsaggi — Wed, 27 May 2015 15:26:48 GMT

Hi Malhar,

Can you share your query. You can use the Date() or Date#() Function in the Load statement while pulling the data from Oracle database.

Regards,
V.

sunny_talwar — Wed, 27 May 2015 15:31:01 GMT

You asked the same question here too: Date Format in QlikView

isorinrusu — Wed, 27 May 2015 15:36:19 GMT

Expanding what vishsaggi said:

If your date format is '11-Sep-1999', you can use Date#(YourDateField, 'DD-MMM-YYY'). This will tell QlikView what format the date is.

If you want to give it a new format, use Date() alongside with Date#():

Date(Date#(YourDateField, 'DD-MMM-YYY'), 'DD/MM/YYYY').

This will have the following output: 11/09/1999.

buzzy996 — Wed, 27 May 2015 15:53:49 GMT

u can try with Date() or Date#() by specifing the format in side the function like 'YYYY/MM/DD'.