Other Unix Time Stamps

Discussion in 'General' started by Shuriken, 18 Feb 2009.

  1. Shuriken

    Shuriken same christmas AV for a whole year

    Joined:
    1 Jan 2003
    Posts:
    1,312
    Likes Received:
    22
    I'm currently working on a website that uses a lot of date sensitive information, so therefore a lot of Unix Time stamps are involved. Anyway, I was just looking at the raw database data and noticed the time stamps at the moment are starting with 1234, which made me wonder what day had the timestamp 1234567890?

    Well, a quick conversion later and I had the date:

    Fri, 13 Feb 2009 23:31:30 GMT

    That's right, Friday the 13th, if I were a superstitious person, I'd be pretty scared right now. :worried:

    TL;DR UTC 1234567890 = Fri, 13 Feb 2009 23:31:30 GMT
     
  2. veryevil

    veryevil Minimodder

    Joined:
    14 Aug 2005
    Posts:
    1,228
    Likes Received:
    34
  3. Shuriken

    Shuriken same christmas AV for a whole year

    Joined:
    1 Jan 2003
    Posts:
    1,312
    Likes Received:
    22
    Damn it, should have know the internet would have beat me to the punch on this. Today is unfortunately the first time I'd considered the possibility of 'interesting' time stamps.

    I suppose next up is 2222222222, was the 18th march 2005 celebrated? (1111111111)
     
  4. jhanlon303

    jhanlon303 The Keeper of History

    Joined:
    7 Sep 2006
    Posts:
    9,263
    Likes Received:
    302
    At Bell Labs in the mid 70's to early 80s, we would ship files between sites with a timestamp of Dec31, 1969. In effect -1 the day before creation.. Unless you were savvy enough to 'touch' the files they were unusable. Unix was still secret to Bell Labs when I first started on it.

    john
     
  5. Shuriken

    Shuriken same christmas AV for a whole year

    Joined:
    1 Jan 2003
    Posts:
    1,312
    Likes Received:
    22
    LIES! You and I both know the universe was in fact formed on the 1st Jan 1970, anyone claiming to be older than 39 is a liar or government agent.

    Edit: Just re-read your post and noticed the mid 70's to early 80's bit, so you're off the hook, but my point remains valid.
     
  6. jhanlon303

    jhanlon303 The Keeper of History

    Joined:
    7 Sep 2006
    Posts:
    9,263
    Likes Received:
    302
    There was life on this planet before the Beatles too.

    john
     
  7. badders

    badders Neuken in de Keuken

    Joined:
    4 Dec 2007
    Posts:
    2,635
    Likes Received:
    72
    <sarcasm> WTF is "the Beatles"? </sarcasm> Har Har Har.

    Ooh Freaky! 9876543210 will also be a Friday! - Fri, 22 Dec 2282 20:13:30 GMT
     
  8. DougEdey

    DougEdey I pwn all your storage

    Joined:
    5 Jul 2005
    Posts:
    13,933
    Likes Received:
    33
    I'm aiming to be here for it
     
  9. Shuriken

    Shuriken same christmas AV for a whole year

    Joined:
    1 Jan 2003
    Posts:
    1,312
    Likes Received:
    22
    Oddly enough 1111111111 was a Friday as well, but 2222222222 isn't.
     
    Last edited: 18 Feb 2009
  10. jhanlon303

    jhanlon303 The Keeper of History

    Joined:
    7 Sep 2006
    Posts:
    9,263
    Likes Received:
    302
    How many post counts will THAT be?

    john
     
  11. DougEdey

    DougEdey I pwn all your storage

    Joined:
    5 Jul 2005
    Posts:
    13,933
    Likes Received:
    33
    Based on current rates, Jamie will need to make the post count a 64bit integer
     

Share This Page