Hi everyone,
I have a column storing Date Time values but is now Varchar type in DB, eg. 2022-09-12 03:53:33 (varchar(19)).
I want to format it to 9/12/2022 03:53 AM
Any recommendation? Thanks a lot for your help :)
Discussion posts and replies are publicly visible
a!localVariables( local!dateAndTime: split("2022-09-12 03:53:33", " "), local!date: split(local!dateAndTime[1], "-"), local!time: split(local!dateAndTime[2], ":"), datetime( local!date[1], local!date[2], local!date[3], local!time[1], local!time[2], local!time[3] ) )
Also: this question gets asked all the time, and I also usually suggest folks who will need to be doing this occasionally, implement a shared expression rule to handle the conversion.
datetime(split(split("2022-09-12 03:53:33"," ")[1],"-")[1], split(split("2022-09-12 03:53:33"," ")[1],"-")[2], split(split("2022-09-12 03:53:33"," ")[1],"-")[3], split(split("2022-09-12 03:53:33"," ")[2],":")[1], split(split("2022-09-12 03:53:33"," ")[2],":")[2], split(split("2022-09-12 03:53:33"," ")[2],":")[3])
Essence of Harshit's solution. You'd think something like this would be built in!