Questions tagged [time zones] (47)

2
answers

Whether to use UTC everywhere on the server?

There are a number of inconveniences in the work over time. On the server one time, in MySQL, other, PHP(Laravel) third. All because of time zones. In addition, periodically, time shifting (summer/winter). At the same time, site visitors - people from different time zones. In General, a mess. In this regard, I decided to ju...
Clare.Schumm asked April 18th 20 at 13:20
2
answers

How to show the user data in the server's time zone and whether you want?

The server time is in UTC. All entity creation time, measured in timestamp and transmitted to the user in the browser in the form of a timestamp and the user on the computer already converted to the date and time. Thus, each user sees the date and time according to your time zone. But there are still functional schedules fo...
Dane.Turcotte asked April 18th 20 at 13:20
3
answers

Why is the time in PHP goes wrong?

Wrote in php.ini your time zone, I deduce:12:04At that moments was really 12 hours, but the minutes were different and there was fixed: next four minutes they had advanced. Now, at seven o'clock, displays 14:04. What to do and why is the time in hours has slowed and in short - stop?
Zander.Larson asked April 16th 20 at 10:40
2
answers

How to update the database of time zones in php?

Hello. phpinfo gives: date/time support enabled timelib version - 2017.09 "Olson" Timezone Database Version - 0.system Timezone Database internal Default timezone is UTC Mind timelib version 2017.09 when there https://pecl.php.net/package/timezonedb version 2019.3 PHP version 7.2.19, which issued may 30, 2019, to my knowle...
Mina_Tremblay43 asked March 31st 20 at 20:38
1
answer

How to read the date and time with timezone?

There is a field of type TIMESTAMP (6) Write in it SYSTIMESTAMP - in database to write the current time (local) (according to the viewer from SQL Developer), but when I read from the database - time is changing (maybe they are already stored with displacement and the viewer from SQL Developer displays the local time). How t...
Jovani.Pag asked March 29th 20 at 23:50
1
answer

How to put Swedish time in Django?

Set in settings TIME_ZONE = 'Europe/Stockholm' but timezone.now() and datetime.now() retain the value on my comp (where the different time zone), how to fix it?
Colby asked March 29th 20 at 20:36
1
answer

How to account for the time difference when working with time zones in php and sql?

Good day! Work with system reports. Encountered a problem while fetching data from the database taking into account time zones. The server is running on Moscow time. When writing data to the database, the client can set the date and time of recording, the record is inserted is not the one specified by the client and transl...
Danny_Rob asked March 17th 20 at 09:31
2
answers

There are alternatives of django-timezones?

Found module datetied to time zones. The author of the well thought out it (for the functionality it suits me), but it looks like in practice and not used. Because it is full of errors, including no support for mysql, and it alone can generate hundreds of queries per page. There are of course different ppl were, but substan...
Erik_Muller76 asked October 14th 19 at 10:40
2
answers

Whether Habr to consider time zones ?

Sometimes a little creepy to see "messages from the future." Says that somebody answered at 20:55, although I have now 19:50. And so now the difference is 1 hour, but you in Russia canceled daylight saving time. Ie, soon the difference will be in 2 hours. Most of the sites that was visited is in the profile setting as to ...
duane_Marks2 asked October 10th 19 at 09:07
4
answers

Wrong time zone in MySQL?

In MySQL, the time is one hour less than the system. Why — is not clear. The problem only showed up on 1 server with the following configuration: OS — Debian GNU/Linux 6.0.3 (squeeze) MySQL 5.1.49 In the system set up correctly the current time and time zone:$ date<br> Mon Nov 7 16:49:10 MSK 2011 Package tzdata update...
alexie_Will14 asked October 9th 19 at 16:36