Date Format

[Anonymous]

Hello,

Looking for help to change the following in the load script:

New_Date

1894-05-14 00:00:00.000000 

to show as:

New_Date

14-05-1894

Thank you

[AshutoshBhumkar]

Hello,

Try this.

Date(Timestamp#('1894-05-14 00:00:00.000000','YYYY-MM-DD hh:mm:ss.ffffff'),'DD-MM-YYYY')

Hope this helps.

Thanks,

Ashutosh

[anat]

LOAD *,date(Floor(dt),'DD-MM-YYYY');
LOAD * Inline [
dt
1894-05-14 00:00:00.000000

];