Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi folks,
Greeting for the day. I have a column which contains date and time in following format;
'24-AUG-21 12:00:00.4660000 AM'
It has string data type.
The desire format is;
24/08/2021 00:00:00
Should have data type timestamp.
is it possible for you to share an app? or share snip of script?
Hi, Akshat
I believe you are writing the formula in analysis window whereas I was trying it in load window.
Hi Sagar,
I have tried it both the ways, data load editor as well as chart expression.
It's working fine. Please find attached screenshots.