I've been agonizing over the best way to store date/time values in my databases (perl will be the app platform).
So, my question is, true or false:, if I want to use SQLite's date/time functions against field values, my only real option is to store YYYY-MM-DD HH:MM:SS time strings. Any other value, whether YYYYMMDD, julian day number, MM/DD/YYYY, etc. (with or without the time portion), would leave me with having to do all format conversions in my app code. TIA -Clark
