Timestamp like 21/09/2024 18:56:03

Stefano_Mazzocca

Is it possible to have a column with such timestamp?

I don't see anything like that:

Bhaskar Konar

Stefano_Mazzocca

Jan 31, 2025

Hi @Bhaskar Konar, I don't have a specific column, I need the current timestamp as column.

My list is this one:

https://us.v-cdn.net/6037859/uploads/P695C06G68DZ/image.png

So if I do CAST(DATE AS TIMESTAMP) I have the wrong time:

https://us.v-cdn.net/6037859/uploads/ZO84X03ZZQ1Y/image.png

Hi @Stefano_Mazzocca,

Thanks for the details.

As per the screenshot the column is only storing the date part and time part you are getting it's a default value like 00:00:00.

If you are looking for Current Timestamp then you can use CURRENT_TIMESTAMP similar like CURRENT_DATE.

Cheers,

Bhaskar Konar

Hi @Stefano_Mazzocca,

Is your source column having Timestamp?

You can CAST a date column to Timestamp in the following way.

CAST("COL NAME" AS TIMESTAMP)

Hope this help.

Cheers,

Stefano_Mazzocca

Hi @Bhaskar Konar, I don't have a specific column, I need the current timestamp as column.

My list is this one:

So if I do CAST(DATE AS TIMESTAMP) I have the wrong time:

Stefano_Mazzocca

Hi @Bhaskar Konar really close!

I now just need to remove the am/pm format (24 hours format) . Is it possible?

Stefano_Mazzocca

Found it!

Thank you

Bhaskar Konar

Stefano_Mazzocca

Jan 31, 2025

Found it!

https://us.v-cdn.net/6037859/uploads/K0MEE7WIK8OC/image.png

Thank you

Glad to hear that.

Thank you very much @Stefano_Mazzocca!