Hello Clark Christensen,
SQLiteSpy executes the query "select date('2005-08-19');" with no problems.
SQLiteSpy is a free SQLite3 database manager and is similar to EXP. To
testdrive SQLiteSpy, download your copy from
http://www.yunqa.de/delphi/sqlitespy/
Regards,
Ralf
>If appropriate for a future rev of SQLite3 Explorer (EXP),
>I'm requesting an update to the handling of date strings.
>
>Using SQLite3 Explorer (EXP) v1.6 under WinXP, "select
>date('2005-08-19')" gives a "not a valid FP number" error.
