Viewing 3 posts - 1 through 3 (of 3 total)
Thanks for your help. You identifying the type of data I'm dealing with put me on the right track to finding the solution.
Here's what works for me:
SELECT DATEADD(s,(-1310389200000/1000),'19700101')
December 6, 2010 at 7:59 am
#1259036
This is what I have so far:
declare @floatdatetime as float
set @floatdatetime = -1310389200000
select DATEADD(ms,
...
December 3, 2010 at 3:30 pm
#1258676
Better not share the name of the software. I've been searching and maybe it's stored as some type of windows file time?
December 3, 2010 at 2:54 pm
#1258662