Need help on date function

[#1]

Hi,

In my tabls the field HIRE_DATE is in format DD/MMM/YYYY(10-Dec-2014).

How to convert this in to number format (DD/MM/YYYY) (10-12-2014)

i tried this but not worked out

Load

HIRE_DATE,

year(HIRE_DATE),

Month(HIRE_DATE),

week(HIRE_DATE),

Day(HIRE_DATE)

Resident EMP;

[MarcoWedel · Accepted solution]

LOAD *,         

          Year(HIRE_DATE) as Year,

          Month(HIRE_DATE) as Month,

          Week(HIRE_DATE) as Week,

          Day(HIRE_DATE) as Day;

LOAD Date(Date#(HIRE_DATE, 'DD-MMM-YYYY'),'DD-MM-YYYY') as HIRE_DATE

Resident EMP;

[#3]

Hello Marcos,

Thanks for the solution.

[MarcoWedel]

You're welcome

regards

Marco