Re: [OT] UNIX timestamp hits 1,000,000,000 this year!
At 00:44 09/03/2001 -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. Has anyone tried to get there artificially and see what breaks ? -- robin b. Suicidal twin kills sister by mistake!
Re: [OT] UNIX timestamp hits 1,000,000,000 this year!
Bill Desjardins <[EMAIL PROTECTED]> writes: > 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. Code which assumes that timestamps can be sorted alphanumerically rather then purely numerically will break too. -- Frank Cringle, [EMAIL PROTECTED] voice: (+49 7745) 928759; fax: 928761
Re: [OT] UNIX timestamp hits 1,000,000,000 this year!
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.
Re: [OT] UNIX timestamp hits 1,000,000,000 this year!
> "Bill" == Bill Desjardins <[EMAIL PROTECTED]> writes: Bill> Just as a FYI about something that caught my attention recently. This year Bill> on Saturday September 8, 2001, the unix time stamp flips to 1 billion and Bill> gets another digit going from 9 to 10 digits. Not sure if anyone else but Bill> me is using the timestamp in ways that were set to 9 digits, such as DB Bill> column int length or in strings of fixed lengths, but these possibilities Bill> should be looked at just in case they could fail when the time changes to Bill> the longer int. Bill> Just a heads up, hope it helps someone. I've been showing it on my homepage for the past 6 months. For an RSS file with the timestamp, invoke http://www.stonehenge.com/u1e9.html And yes, I've written programs that will definitely break on that time. So if I've done it, I bet others have done it as well. The sad thing is that unlike Y2K, this thing cuts in all at the same time all over the world. Fun fun fun. -- Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095 <[EMAIL PROTECTED]> http://www.stonehenge.com/merlyn/> Perl/Unix/security consulting, Technical writing, Comedy, etc. etc. See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!
[OT] UNIX timestamp hits 1,000,000,000 this year!
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. Just a heads up, hope it helps someone. Bill -- Bill Desjardins - [EMAIL PROTECTED] - (USA) 305.205.8644 Unix/Network Consulting - perl/mod_perl/SQL development http://www.CarRacing.com - Powered by FreeBSD/mod_perl http://www.FreeBSD.org - The Best OS Money can't buy f u cn rd ths, u cn gt a gd jb n cmptr prgrmmng...