nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

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:

Find more posts tagged with

Timestamp

Fusion AI Data Platform

Accepted answers

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/63379#Comment_63379

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,

All comments

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:

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/63379#Comment_63379

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,

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

https://community.oracle.com/products/oracleanalytics/discussion/comment/63382#Comment_63382

Glad to hear that.

Thank you very much @Stefano_Mazzocca!

Upcoming Event

Oracle AI World 2026
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…

Top Leaders