Unix Timestamp

Anon

Hi !
Now, the timestamp is 9949...
What will append in few days ? One digit more ?

renegade888

Well, technically the UNIX timestamp is the number of seconds that have elapsed since the epoch, which I believe is Jan 1, 1969. So, the number should increment each second. One last off topic note: the timestamp will overflow sometime around 2031 or so.

Correct me if I am wrong.

Hope this helps.
Ken

cordex

Right-o kharris, 1 day = 86400 seconds (246060=86400)
(but Unix epoch was Jan 1, 1970)

Another off topic note: Sat, September 08, 2001, at 2046 (8:46pm) and 40 seconds the Unix timestamp will reach the 1000000 mark on my server. Do you have your Unix Million Second parties planned?

-Ben

Anon

I have been wondering the same thing. It will turn over on Sept 9th sometime. I forget what time exactly. You can search it google. just type "timestamp 1000000000". But nothing should happen EXCEPT for people who made databases with a timestamp field and made it an int(9). That would screw up some systems pretty bad i would think, as well as corrupt the data. Let's just hope our banks haven't done that, or anyone else. I almost did it to a database i was working on.

Anon

1000000????? Uh, one million seconds passes every 11-12 days. you must have meant billion(1000000000)

cordex

So I did.
1000000000 it is.

hessian

Figured I would add this, source www.dictionary.com

[Unix: probably from astronomical timekeeping] The time and date corresponding to 0 in an operating system's clock and timestamp values. Under most Unix versions the epoch is 00:00:00 GMT, January 1, 1970; under VMS, it's 00:00:00 of November 17, 1858 (base date of the US Naval Observatory's ephemerides); on a Macintosh, it's the midnight beginning January 1 1904. System time is measured in seconds or ticks past the epoch. Weird problems may ensue when the clock wraps around (see wrap around), which is not necessarily a rare event; on systems counting 10 ticks per second, a signed 32-bit count of ticks is good only for 6.8 years. The 1-tick-per-second clock of Unix is good only until January 18, 2038, assuming at least some software continues to consider it signed and that word lengths don't increase by then. See also wall time.