Categories
- All Categories
- Oracle Analytics Learning Hub
- 32 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 255 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 95 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Timestamp like 21/09/2024 18:56:03
Is it possible to have a column with such timestamp?
I don't see anything like that:
Best Answer
-
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,
1
Answers
-
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,
0 -
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:
0 -
Hi @Bhaskar Konar really close!
I now just need to remove the am/pm format (24 hours format) . Is it possible?
0 -
Found it!
Thank you
1 -
Glad to hear that.
Thank you very much @Stefano_Mazzocca!
0