I'm confused about date and time. Could someone help me by telling me what it does when it's selected and when it's not selected? From what I've read, when I want to record the current time from the server, I use NOW, when I want to record the local time, its NOW_UTC. Since I'm leaning towards using NOW_UTC when recording a current date and time, do I need to enable "use timezone"? What does it do?
1 Like
The answer may be simple for some, but for me I don't know what it means to have this enabled or not. I always try to research before asking any questions here. I found a wide discussion about time zones, but nothing about this button. I searched the documentation, but I didn't find anything there either.
I'm formatting a database and I want to understand to see if I should enable it or not, any help will be welcome.
Have a look at this:
I've read it a few times but nothing is said about this check button
If I set up all that in @Teodor tutorial, what is this check for?
The use timezone is a specific option for postgresql databases to store the datetime with timezone information.
Thanks for the answer. Now I know that there is no need for me to use it, so much so that when I try to use it, it does not enable it and I get a warning message saying "nothing to do!". My database is MariaDB, it is not necessary.
But in short, we would have saved time if when I clicked on the "i" for information, I would have had this clarified.
Let's move on.