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
Смотрите видео The UTC timezone. Why SYSDATE might be wrong for you онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь SQL and Database explained! 01 Март 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 3,906 раз и оно понравилось 101 людям.