Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    2

    Unanswered: How do I convert UNIX timestamp to mm/dd/yyyy format?

    I have a table that is imported into SQL 2000 from a Sybase box. The date is an integer unix timestamp (number of seconds from 1/1/1970 at midnight). How can I convert this into a format of mm/dd/yyyy ?

    Thanks in advance

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    dateadd(ss,<your Unix Timestamp>,'1/1/1970')
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

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