The UTC timezone. Why SYSDATE might be wrong for you

Two of the most common date expressions we will ever type are "SYSDATE" and "SYSTIMESTAMP". But when you move your database to cloud, those functions might not do what you are expecting them to do for client facing parts of your application. But before you start to rewrite all of your code to use CURRENT_DATE and CURRENT_TIMESTAMP, there might be an easier solution. SQL Translation Profiles can dynamically change your SQL as it is passed to the database...


blog: https://connor-mcdonald.com
twitter:   / connor_mc_d  

Subscribe for new tech videos every week

All other social media channels here: https://linktr.ee/connor


Are you serious? A free Oracle database forever ?!?!?!?! Oh yeah!!!

https://www.oracle.com/cloud/free



Music: Kevin Mcleod, incomptech

#sysdate #cloud #translation