App::Prove::History

[Ovid]

----- 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:

  http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions

Those were added in 3.2 and DBD::SQLite uses 3.4.2.  No idea how useful they really are, though.

Cheers,
Ovid
--
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