Great thanks. I also noticed that the format I typed below is wrong. The sqlite website (and what I actually see in the db) is:
YYYY-MM-DD HH:MM:SS -Brad > -----Original Message----- > From: Cariotoglou Mike [mailto:[EMAIL PROTECTED] > > Will fix and let you know > >> -----Original Message----- >> From: Brad Schick [mailto:[EMAIL PROTECTED] >> >> Is it possible to get SqliteExplorer to parse textual dates in the >> ISO8601 format of: >> >> yyyy-MM-dd HH-mm-ss >> >> I believe this is the format that sqlite uses itself for >> CURRENT_TIMESTAMP, et. al. >> >> I'm running SqliteExplorer 1.3 on WinXP with "Use Datatypes" >> and "Dates as Text" enabled and it only seems to parse dates >> slash seperators like 2005/04/27. Of course I can work around >> this by disabling datatypes, but I like the extra error >> checking provided by datatypes.
