Convert date time field to timestamp

[Sagar082]

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.

[PrashantSangle]

Check timestamp() and Timestamp#()

[PrashantSangle]

=TimeStamp(Timestamp#('24-AUG-21 12:00:00.4660000 AM','DD-MMM-YY hh:mm:ss.ffff TT'))

[akshatagrawal]

use this

TimeStamp(Timestamp#(ColumnName,'DD-MMM-YY hh:mm:ss.ffff TT'),'DD/MM/YYYY hh:mm:ss') as ColumnName

[Sagar082]

Hi,

Thank you for reply. But, it is not working.

[PrashantSangle]

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..

[Sagar082]

It is not giving error. It is not computing value, output is "-"

[akshatagrawal]

not sure, why it's not working for you. Please find below screenshot.

load * Inline
[
time1
24-AUG-21 12:00:00.4660000 AM
];

[PrashantSangle]

where you are writing?? in text box or in script??

[Sagar082]

Hi, Prashant

I'm writing in script, as keen to have column to make different operations.