Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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]
DATE(DATE#(YourDateColumn, 'DD/MM/YYYY hh:mm:ss'), 'YYYY-DD-MM hh:mm:ss') AS RequiredFormat