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!
