mysql> select @@global.time_zone,@@session.time_zone;
+--------------------+---------------------+
| @@global.time_zone | @@session.time_zone |
+--------------------+---------------------+
| SYSTEM | SYSTEM |
+--------------------+---------------------+
1 row in set (0.00 sec)
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2007-12-14 00:46:33 |
+---------------------+
1 row in set (0.00 sec)
mysql> select unix_timestamp();
+------------------+
| unix_timestamp() |
+------------------+
| 1197560805 |
+------------------+
1 row in set (0.00 sec)
mysql> \! date -d '1970-010-01 UTC 1197560805 seconds';
Fri Sep 12 00:46:45 JST 2008
mysql> \! date
Fri Dec 14 00:48:22 JST 2007
mysql>
评论