hi,
is this normal?
how can i get a timestamp of dates before 1970?
thanks.
ati
mysql> select from_unixtime(-86400);
+-----------------------+
| from_unixtime(-86400) |
+-----------------------+
| 1969-12-31 01:00:00 |
+-----------------------+
1 row in set (0.00 sec)
mysql> select unix_timestamp('1969-12-31 01:00:00');
+---------------------------------------+
| unix_timestamp('1969-12-31 01:00:00') |
+---------------------------------------+
| 0 |
+---------------------------------------+
1 row in set (0.00 sec)
debian linux 2.2.17
mysql 3.23.36-log
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php