Results 1 to 1 of 1
  1. #1
    Join Date
    Apr 2003

    Unanswered: Converting unix time into something readable

    I'm having trouble converting a standard unix-time format value into something that's actually readable.

    I have a large number that's actually the number of seconds since
    1970-01-01 00:00:00 (I think so) until now. I really don't know the date converting rules and exceptions well, so I doubt I could write a correct conversion on my own.

    Three o'clock in the afternoon on Tuesday, April 30, 1996 is 830898000 seconds. (at least I've been told so)

    Does anyone know if I can find a function or stored procedure somewhere that can convert this 830898000 value into something that's readable?

    I'd be grateful for any help with this..

    EDIT: Okay, I should've tried searching some more on those forums. I got what I needed, don't bother about this one. It's really pretty simple: select dateadd(ss, <timestamp>, '1/1/1970') and you got something that's nice and readable.
    Last edited by macke; 04-03-03 at 06:57.

Posting Permissions

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