Date Formatting from YYYY-MM-DD hh:mm:ss to YYYY-DD-MM hh:mm:ss

[hariprasad_r]

Qlik guns,

Can any one help me in converting the datetime format from YYYY-MM-DD hh:mm:ss to YYYY-DD-MM hh:mm:ss with 24 hrs time format.

[andrey_krylov]

Try this

Re: Convert 12 Hour to 24 Hour Timestamp

TimeStamp(Timestamp#([Created Date],'DD/MM/YYYY hh:mm:ss TT'),'DD/MM/YYYY hh:mm:ss') as [Created Date]

[nsetty]

DATE(DATE#(YourDateColumn, 'DD/MM/YYYY hh:mm:ss'), 'YYYY-DD-MM hh:mm:ss') AS RequiredFormat