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 Analytics and AI

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!