Results 1 to 3 of 3

Thread: Timestamp Convertion...

  1. Jan 24th, 2003, 08:35 AM #1
    Chrissie
    Chrissie is offline

    Thread Starter
    Lively Member
    Join Date
    Aug 2002
    Location
    The Netherlands
    Posts
    96

    Timestamp Convertion...

    I'm importing an Access database into SQL Server...I come across Timestamps which look like the ones below. In the Access database the field is set to be a Double Number.

    OPENEDTIME
    37265,7135185185
    37127,5163541667
    37315,7006481482
    37585,4245138889
    37585,4308101852
    37113,3796412037

    How can I create a nice looking time from these stamps? (Using ASP and SQL server)
    Reply With Quote Reply With Quote
  2. Jan 24th, 2003, 11:30 AM #2
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758
    The Date datatype is basically equivalent to a Double. So all you need to do is format the values.

    Format$(37113.3796412037, "dd-MMM-yyyy hh:nn:ss") would be 10-Aug-2001 09:06:41

    No conversion is necessary when inserting those values into a SQL Server datetime field.
    Reply With Quote Reply With Quote
  3. Jan 27th, 2003, 06:34 AM #3
    Chrissie
    Chrissie is offline

    Thread Starter
    Lively Member
    Join Date
    Aug 2002
    Location
    The Netherlands
    Posts
    96
    Thanks..that conversion works for Access....

    Does a function exist to do exactly the same in SQL Server?
    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