Date Format

[#1]

How to convert date format in oracle query.

[vishsaggi]

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]

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

[isorinrusu]

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]

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