Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello !
Can one help me on this format below
I have column as 'PublishedTime' and the value as 'Jan 28, 2022 10:40 AM'
However i would need it as "DD-MM-YYYY HH:MM:SS" (In 24 Hours Format )
Kindly help on the same
Thanks in Advance!
Ajay533633
try this:
date(date#(PublishedTime,'MMM DD, YYYY hh:mm TT'),'DD-MM-YYYY hh:mm:ss') as PublishedTime_New
Timestamp(Timestamp#(PublishedTime,'MMM DD, YYYY hh:mm TT'),'DD-MM-YYYY hh:mm:ss') as " 24HourPublishedTime"