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.
Check timestamp() and Timestamp#()
=TimeStamp(Timestamp#('24-AUG-21 12:00:00.4660000 AM','DD-MMM-YY hh:mm:ss.ffff TT'))
use this
TimeStamp(Timestamp#(ColumnName,'DD-MMM-YY hh:mm:ss.ffff TT'),'DD/MM/YYYY hh:mm:ss') as ColumnName
Hi,
Thank you for reply. But, it is not working.
what do you mean by not working?? is it giving you any error? or giving you wrong output? can you share some screenshot of it..
It is not giving error. It is not computing value, output is "-"
not sure, why it's not working for you. Please find below screenshot.
load * Inline
[
time1
24-AUG-21 12:00:00.4660000 AM
];
where you are writing?? in text box or in script??
Hi, Prashant
I'm writing in script, as keen to have column to make different operations.