I've found some functions to convert a unix timestampt (bigint) to a SQL 2005 datetime. I'm using the following code:
select dateadd(ss, startdate/1000, '1970-01-01') as DateStarted from mdl_course
Thats fine, except these aren't the results aren't exactly what I was looking for:
I know these are dates that should begin in 2006. Not sure how to get these to the actual date.
The data in the column I'm querying is as follows:
Thanks for any assistance!