Categories
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
