>>>>> "Steve" == Steve Ruby <stever@stripped> writes:
Steve> unix_timestamp() function appears to break around 2038 so
Steve> becarefull what you use to compare dates well into the future.
Before 2038, the Unix systems will to use for a timestamp:
- An unsigned 32 bit value instead of an ulong
(This will be safe with until 21xx something)
- A 64 bit value.
In either case, MySQL should work until 21xx with the current
MySQL TIMESTAMP implementation (MySQL will continue to store the
timestamp as an unsigned 32 int until 2099. We plan to fix this in
MySQL version 13.0).
Regards,
Monty