The beauty of UTC is that it is not a time zone as such but a reference time, and it is not subject to daylight savings time. It is simply the globally recognized coordinated universal time. GMT, however is not the same thing. It is the time zone of the United Kingdom when they are on standard (Winter) time. But, I have observed system admins treating GMT as if it is like UTC and then wonder why their server goes into DST unexpectedly. It is good practice to set server clocks to UTC and utilize built-in database features for handling time zones. Oracle has particularly powerful tools for this. Cheers, Russ
The beauty of UTC is that it is not a time zone as such but a reference time, and it is not subject to daylight savings time. It is simply the globally recognized coordinated universal time. GMT, however is not the same thing. It is the time zone of the United Kingdom when they are on standard (Winter) time. But, I have observed system admins treating GMT as if it is like UTC and then wonder why their server goes into DST unexpectedly. It is good practice to set server clocks to UTC and utilize built-in database features for handling time zones. Oracle has particularly powerful tools for this. Cheers, Russ
That is a really really handy demo! Thanks Connor!
Never even knew this existed. Great info!
Glad it was helpful!
DBMS_ADVANCED_REWRITE is one of the earlier option to convert statements.
Are you drunk 😜🤪