Archive for the "Oracle" category

 

Getting SYSDATE in UTC (GMT) time

 
Overview Recently I have a task to change all the “last_update_date” column in our tables to store UTC (GMT) time. The “last_update_date” column with data type DATE stores the datetime where the row is last updated. I found that the system originally use SYSDATE to populate the value of “last_update_date” column, and the [...]

Continue reading