10 digit date?

Discussion in 'Databases' started by mipa jim, Mar 17, 2006.

0
  1. #1
    I have a database that has a ten digit date (int) field
    number looks like this:
    1142429652

    Best I can figure it translates to the number of seconds since the Magna Carta or the Treaty of Versailles or maybe since Columbus supposedly found America.

    Can anyone translate this one for me?

    Tks.
     
    mipa jim, Mar 17, 2006 IP
  2. lorien1973

    lorien1973 Notable Member

    Messages:
    12,206
    Likes Received:
    601
    Best Answers:
    0
    Trophy Points:
    260
    #2
    isnt that the numerical number down to the second since 1970? In c you have you cdate(1142429652); to get the actual date it represents. I don't know how to convert it otherwise
     
    lorien1973, Mar 17, 2006 IP
  3. mipa jim

    mipa jim Peon

    Messages:
    261
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #3
    ok, maybe.... so what so historic happened in 1970?
     
    mipa jim, Mar 17, 2006 IP
  4. lorien1973

    lorien1973 Notable Member

    Messages:
    12,206
    Likes Received:
    601
    Best Answers:
    0
    Trophy Points:
    260
    #4
    I dunno. I think its just the standard that it was set to.

    seems right too:

    1 142 429 652 seconds = 36.2021844 years

    1970 + 36.2021844 = 2006.2021844
     
    lorien1973, Mar 17, 2006 IP
  5. Sholva

    Sholva Peon

    Messages:
    154
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Some UNIX programmer(s) decided Jan 1, 00:00:00 UTC 1970 would make a nice date for the UNIX epoch. Don't ask me why... as I think UNIX wasn't around until 1972? I guess they liked even dates.

    It runs out sometime in 2038 if they are still using POSIX time with a signed 32 bit integer. I suspect by then people won't be silly enough to make such a big deal of it... like with Y2K.
     
    Sholva, Mar 21, 2006 IP