I store datetime values in the database as sql float type (Converted from an DateTime.OADate) for a myriad of reasons however in certain circumstances it is nice to get a human readable date/time column back from the database. I have found that I can execute the statement

```
SELECT CAST (timerecorded_utc as DATETIME) FROM tablename

```

and it will give me the date time string I am looking for but it seems to be off by exactly 2 days. I realize I can just modify the statement (since in time represented as a double 1 day = 1.0) to be 

```
SELECT CAST (timerecorded_utc-2.0 as DATETIME) FROM tablename

```

BUT I was wondering if this is consistent AND it seems to me there is some reason for the discrepancy that I am missing.