Printable View
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)
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.
Thanks..that conversion works for Access....
Does a function exist to do exactly the same in SQL Server?