Format date

[penpayom]

Hi

I want to Format date from YYYY-MM-DD hh:mm:ss to DD/MM/YYYY ,but some output data uncorrected ,it Show "-" 

What Happen with my date. Please help me.

thank you.

Code

Output

[MarioCenteno]

Try

Date(Date#([SO_NO_DATE],'YYYYMMDD'),'DD/MM/YYYY') as [SO_NO_DATE]

[Anonymous]

Try this:

Date( Floor( Timestamp#( SO_NO_DATE, 'YYYY-MM-DD hh:mm:ss')), 'M/D/YYYY') as SO_NO_DATE

[Anonymous]

can you try

Date(DayStart(floor([SO_NO_DATE])),'DD/MM/YYYY') as [SO_NO_DATE]

[balabhaskarqlik]

Use this:

DFIT_SO_HEADER:

LOAD

    SO_NO,

    SO_NO_DATE,

    DAYNAME(SO_NO_DATE) AS OPEN_ORDER,

    DATE(timestamp#(SO_NO_DATE,'MM/DD/YYYY h:mm:ss TT')) as OPEN_ORDER,

    Date(Floor(SO_NO_DATE)) as OPEN_ORDER,

    Date(Floor(Date(Date#(Left(SO_NO_DATE,Len(SO_NO_DATE)-10),'MM/DD/YYYY hh:mm:ss TT'))),'DD/MM/YYYY')

From ABC.csv;

Follow different formats to remove the extra timestamp.