Re: [sqlite] Another Date Question

Thank you Steven and Igor. Both methods worked. Rene -- Forwarded message -- From: steven.far...@dds.net To: General Discussion of SQLite Database 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

Re: [sqlite] Another Date Question

Rene Claassen 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; > 39

Re: [sqlite] Another Date Question

PM ?cdate(39895.57176) 3/23/2009 1:43:20 PM Hope this helps. Rene Claassen Sent by: sqlite-users-boun...@sqlite.org 04/29/2009 09:18 AM Please respond to General Discussion of SQLite Database To sqlite-users@sqlite.org cc Subject [sqlite] Another Date Question I've had a pr

[sqlite] Another Date Question

I've had a problem before where I received an 'Invalid Use of Null' error when I'm quering a DateTime field from vb6. Olaf send me a link to another class, and when I used that I could query the data, but I still have a problem if I want to link to the data from MS Access or Cold Fusion. If I do a