Re: [sqlite] Storing dates/times (was: SQL help)

2011-12-22 Thread Simon Slavin
On 22 Dec 2011, at 10:29pm, Richard Hipp wrote: > http://en.wikipedia.org/wiki/ISO_8601 Wow. Yes, that's where I got the 'T' from. But I seem to have forgotten or ignored everything else from it. Possibly back in the days when storing those extra slashes would have cost me or my customers s

Re: [sqlite] Storing dates/times (was: SQL help)

2011-12-22 Thread Richard Hipp
On Thu, Dec 22, 2011 at 5:25 PM, Simon Slavin wrote: > > On 22 Dec 2011, at 9:44pm, Jean-Christophe Deschamps wrote: > > > IMHO if dates are to be stored in string format, then one should always > store them in /MM/DD (with leading zeroes) then eventually display > dates in whatever format su

[sqlite] Storing dates/times (was: SQL help)

2011-12-22 Thread Simon Slavin
On 22 Dec 2011, at 9:44pm, Jean-Christophe Deschamps wrote: > IMHO if dates are to be stored in string format, then one should always store > them in /MM/DD (with leading zeroes) then eventually display dates in > whatever format suits users at the application level. To save you time in t