Rene Claassen <claassen.r...@gmail.com>
wrote:
> If I do a normal select on the field in SQLite2008 I get the
> following: Select Date_Stamp
> from in_wt;
> 2009-03-23 13:27:38
> 2009-03-23 13:43:20 etc
>
> And lastly if convert it to a float it gives the following:
> Select cast(Date_Stamp as float)
> from in_wt;
> 39895.56086 39895.57176
What you seem to have stored in your table is the number of days since
midnight 1899-12-30 (which, I believe, is Visual Basic's internal format
for dates). Try this:
select datetime(Date_Stamp + julianday('1899-12-30'))
from in_wt;
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
