What is the timezone in SQL and why is it needed? | Sololearn: Learn to code for FREE!
+ 1

What is the timezone in SQL and why is it needed?

I already "zadolbalsya"! I have a problem with the interaction of Java with sql, but everyone writes that because of some timezone. I can post my code if you want then to write "yeah, man!".

25th Apr 2019, 9:35 AM
Bew Nosm
Bew Nosm - avatar
1 ответ
+ 8
The usage of time zones in applications becomes inevitable, especially with the globalization of the applications. Reports need to be run in different time zones. Services have to consider the time zones. Applications’ users nowadays, which are around the globe use their local zones and etc. The programming on database level also requires usage of the time zones. In this post there are some examples that will demonstrate usage of time zones. With SQL Server 2016 you can obtain the corresponding time in another time zone from an initial These links will be helpful for u😊😊 https://www.google.com/url?sa=t&source=web&rct=j&url=https://dba.stackexchange.com/questions/39421/how-to-handle-timezone-properly-in-sql-server&ved=2ahUKEwjyu9j0-erhAhVJKY8KHc6HCVwQFjABegQIBxAC&usg=AOvVaw2PhogFQzkRnvbZoj-90kOb https://www.google.com/url?sa=t&source=web&rct=j&url=https://dzone.com/articles/dates-and-times-in-sql-server-at-time-zone&ved=2ahUKEwjyu9j0-erhAhVJKY8KHc6HCVwQFjAAegQIBRAB&usg=AOvVaw0w0fRi48jNqQy7lP3jb1Mh&
25th Apr 2019, 9:44 AM
Prince PS[Not_Active]
Prince PS[Not_Active] - avatar