publiustemp-tapx at yahoo.com
Fri Sep 19 09:52:52 UTC 2008
----- Original Message ----
> From: Andy Armstrong <andy at hexten.net>
> > I intend to store times in this format: 2008-09-18T16:00:28.79858,
> > but I don't know if SQLite can really handle date functions terribly
> > well (seems limited). Is that a fine format, or should I use epoch
> > time? Other things people would want?
> I'd lean towards epoch for easier comparison on SQLite.
That's what I initially thought, but when working directly in the database, I found it very frustrating to see start times of 1221753628.79859.
Are dates in SQLite really that bad? I see date functions for it:
Those were added in 3.2 and DBD::SQLite uses 3.4.2. No idea how useful they really are, though.
Buy the book - http://www.oreilly.com/catalog/perlhks/
Tech blog - http://use.perl.org/~Ovid/journal/
Twitter - http://twitter.com/OvidPerl
Official Perl 6 Wiki - http://www.perlfoundation.org/perl6
More information about the tapx-dev