Re: [OT] UNIX timestamp hits 1,000,000,000 this year!

[Tim Bunce]

On Fri, Mar 09, 2001 at 12:44:59AM -0500, Bill Desjardins wrote:
> 
> Just as a FYI about something that caught my attention recently. This year
> on Saturday September 8, 2001, the unix time stamp flips to 1 billion and
> gets another digit going from 9 to 10 digits. Not sure if anyone else but
> me is using the timestamp in ways that were set to 9 digits, such as DB
> column int length or in strings of fixed lengths, but these possibilities
> should be looked at just in case they could fail when the time changes to
> the longer int.

Another common bug-waiting-to-happen is sorting the unix time stamp
values as strings instead of numbers.

Tim.