Date Format returns NULL value

[Anonymous]

Hi, i have a question. I have a data like this before formatting

I want to change the date format into 'MM/dd/yyyy' by using this function in load script

date(SHIP_DATE,'MM/dd/yyyy') as SHIP_DATE

But when data load is finished it returns null like this:

I also do this to another fieldname and it runs perfectly, only "SHIP_DATE" field returns null.

Anybody know what's the problem ?

really appreciate your help

Thanks

[nagarjuna_kotha]

Hi Try this:

date(SHIP_DATE,'MM/DD/YYYYY') as SHIP_DATE

[Anonymous]

Hi All,

Thanks for your answer, it is very helpful to solve my problem.

Thanks in advance