The Y2038 "bug"
| From: | Justin French | Date: | Thu, 12 Aug 2004 14:16:42 +0000 |
| Subject: | The Y2038 "bug" | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-193573@lists.php.net to get a copy of this message | ||
Hi all,
Is anyone giving much thought to the Y2038 "bug/issue" in relation to Unix Timestamps? From what I read, they have a range of 1970-2038 (or earlier than 1970 on *nix).
The reason I ask is because I always store my dates in timestamps, and I don't really want to be responsible for any more short-sighted code/data that may still be around 34 years from now.
My thinking is to store everything in MySQL DATETIME format (YYYY-MM-DD HH:II:SS), but perhaps there's some other thinking on the situation?
---
Justin French
http://indent.com.au