Re: [sqlite] SQLite 3.0.8 dates

On Fri, 4 Feb 2005 12:09:59 -0800 (PST), you wrote: >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

Re: [sqlite] SQLite 3.0.8 dates

Clark Christensen wrote: 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 -MM-DD HH:MM:SS

Re: [sqlite] SQLite 3.0.8 dates

Friday, February 4, 2005, 3:09:59 PM, Clark Christensen wrote: > 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 -MM-DD HH:MM:SS time strings. > Any other value, whether MMDD, julian day number,

[sqlite] SQLite 3.0.8 dates

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 -MM-DD HH:MM:SS time strings. Any other