SELECT
TIMEDIFF(NOW(), UTC_TIMESTAMP);
+--------------------------------+
|
TIMEDIFF(NOW(), UTC_TIMESTAMP) |
+--------------------------------+
|
02:00:00 |
+--------------------------------+
1
row in set (1.18 sec)
php
-i | grep timezone
PHP
Warning: Unknown: It is not safe to rely on the system's
timezone settings. You are *required* to use the
date.timezone setting or the date_default_timezone_set()
function. In case you used any of those methods and you are
still getting this warning, you most likely misspelled the
timezone identifier. We selected the timezone 'UTC' for now,
but please set date.timezone to select your timezone. in
Unknown on line 0
Default
timezone => UTC
date.timezone
=> no value => no value
date
+%::z
+02:00:00
Tomasz Karczewski
Administrator Sieci
http://www.man.olsztyn.pl
http://www.uwm.edu.pl
tel. (89) 523 45 55 fax. (89) 523
43 47
Ośrodek Eksploatacji i Zarządzania
Miejską Siecią Komputerową OLMAN w
Olsztynie
Uniwersytet Warmińsko-Mazurski w
Olsztynie
From:
observium [mailto:observium-bounces@observium.org] On
Behalf Of Mike Stupalov
Sent: Wednesday, September 10, 2014 1:00 PM
To: Observium Network Observation System
Subject: Re: [Observium] Eventlog time and date
Hi,
On 10.09.2014 13:07, Tomasz Karczewski wrote:
Hi there,
I've got one question.
Fresh eventlogs and syslogs have format -1y -1d -2h .
How to change it?
pls show some info for your
server:
1. mysql timezone, from console:
$ mysql
SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);
2. php timezone:
$ php -i | grep
timezone
3. system timezone:
$ date +%::z
Tomasz
Karczewski
Administrator
Sieci
http://www.man.olsztyn.pl
http://www.uwm.edu.pl
tel. (89) 523
45 55 fax. (89) 523 43 47
Ośrodek
Eksploatacji i Zarządzania
Miejską Siecią
Komputerową OLMAN w Olsztynie
Uniwersytet
Warmińsko-Mazurski w Olsztynie
_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
--
Mike Stupalov
http://observium.org
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium