Results 1 to 4 of 4

Thread: **RESOLVED thanks tr0n** Date/time: seconds since 1970

  1. Aug 1st, 2002, 07:58 AM #1
    Jim Brown
    Jim Brown is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2000
    Posts
    350

    Question **RESOLVED thanks tr0n** Date/time: seconds since 1970

    Yuck!

    Some data we get from Solaris systems has time stamps as seconds since 1970 (I think... I need to check the specifics!) I need to convert these to the actual date and time.

    Thus 1 028 135 754 seconds is 31 July 2002, at 17:15:54

    If it wasn't for the fact that months have different numbers of days, not to mention leap years, this would be a straight forward bit of arithmetic. But of course it's not that simple...

    Anyone done this or anything similar before. All ideas welcome.
    Last edited by Jim Brown; Aug 1st, 2002 at 08:18 AM.
    .
    Reply With Quote Reply With Quote
  2. Aug 1st, 2002, 08:05 AM #2
    tr0n
    tr0n is offline
    Fanatic Member
    Join Date
    Apr 2002
    Posts
    638
    VB Code:
    1. dateadd("s","1028135754","01/01/1970")

    Reply With Quote Reply With Quote
  3. Aug 1st, 2002, 08:16 AM #3
    Jim Brown
    Jim Brown is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2000
    Posts
    350

    Red face

    Deletes thread in embarrasment hoping noone will laugh at me missing something quite that simple....



    .
    Reply With Quote Reply With Quote
  4. Aug 1st, 2002, 08:24 AM #4
    tr0n
    tr0n is offline
    Fanatic Member
    Join Date
    Apr 2002
    Posts
    638
    teehee
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width