Exporting Data - Dates
I am trying to export data from SupportDesk - workorder table into MS SQLServer, which I am able to do using EMS SQL Manager 2005.
The issue is that dates are stored as BigInt(20), and I want them imported into SQL Server as DateTime.
I have discovered that the BigInt value is the number of milliseconds since 1/1/1970, so it would be possible to convert the number to DateTime in Excel
(BigIntValue/24/60/60/1000 +25569). eg
1156413318536 is equal to 24/08/2006 09:55:19
Is there a simpler way to Export these date values into SQLSever, as this is crucial to the purchase of the application?
The issue is that dates are stored as BigInt(20), and I want them imported into SQL Server as DateTime.
I have discovered that the BigInt value is the number of milliseconds since 1/1/1970, so it would be possible to convert the number to DateTime in Excel
(BigIntValue/24/60/60/1000 +25569). eg
1156413318536 is equal to 24/08/2006 09:55:19
Is there a simpler way to Export these date values into SQLSever, as this is crucial to the purchase of the application?