It was set as String actually. I've since changed it to ShortDate today.
I believe this is a WRAPPER thing though. I'm programming in VB6 and using Olaf's VB wrapper. :) Rick #>-----Original Message----- #>From: sqlite-users-boun...@sqlite.org #>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rich Shepard #>Sent: Monday, August 03, 2009 3:45 PM #>To: General Discussion of SQLite Database #>Subject: Re: [sqlite] Date Comparisons SQL #> #>On Mon, 3 Aug 2009, Rick Ratchford wrote: #> #>> The native Date in a table without any additional expressions is #>> 'yyyy-mm-dd 00:00:00'. #> #>Rick, #> #> That's a timestamp format. Did you specify the column as #>date or timestamp? #> #>Rich #> #>-- #>Richard B. Shepard, Ph.D. | Integrity #> Credibility #>Applied Ecosystem Services, Inc. | Innovation #><http://www.appl-ecosys.com> Voice: 503-667-4517 #>Fax: 503-667-8863 #>_______________________________________________ #>sqlite-users mailing list #>sqlite-users@sqlite.org #>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users #> #> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users