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
We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
How to ADD/REMOVE Security Assignments Automatically -- need help with time/date format
MayM
Rank 1 - Community Starter
I'm having trouble updating security assignments automatically. I believe it is not working due to time/date format issues.
How can you get creation_date in the correct format?
According to the documentation, the CREATION_DATE column should be type TIMESTAMP (6) and in "2024-02-21 12:34:56.789" format. However, when setting the creation_date value only the systimestamp and to_timestamp functions worked, both of which returned the time in "06-AUG-24 09.01.01.274614000 PM" format. I also tried hard cording it (SET creation_date = "2024-08-06 13:15:00.000") which didn't work.
Any tips on how to get "2024-02-21 12:34:56.789" format? Thanks!
0
Best Answer
-
Can you please check if this forum discussion helps you?
0
