How to ADD/REMOVE Security Assignments Automatically -- need help with time/date format

MayM

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!

BalagurunathanBagavathy-Oracle

@MayM

Can you please check if this forum discussion https://forums.oracle.com/ords/apexds/post/datatype-timestamp-6-issue-to-insert-8899 helps you?