Thank you Steven and Igor. Both methods worked. Rene
---------- Forwarded message ---------- From: steven.far...@dds.net To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Date: Wed, 29 Apr 2009 11:56:15 -0400 Subject: Re: [sqlite] Another Date Question If you just convert that floating number back to a date using the CDate Function. It properly converts it back. Open the vb project and do not run it but just open the Immediate window and type the following lines and you will see it do the conversion. ? cdate(39895.56086) 3/23/2009 1:27:38 PM ?cdate(39895.57176) 3/23/2009 1:43:20 PM Hope this helps. <http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> 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
