On Tuesday 05 July 2005 09:53 am, Cory Nelson wrote:
> Just an educated guess, but probably because sqlite tries to be as
> minimal as possible. Which I have no complaints with, as comparing a
> double will likely be faster than comparing a string.
I personally store all mine like this anyway using unix time so I can change
the format at anytime. plus it's not only faster to compare programming wise,
just compare numbers. no need use functions.
strings also are larger than numbers in size wise so you save a few bytes here
and there.
>
> On 7/5/05, Johan Danielsson <[EMAIL PROTECTED]> wrote:
> > Cory Nelson <[EMAIL PROTECTED]> writes:
> > > create table t_foo(bar real);
> > > insert into t_foo values(julianday('2005-07-01'));
> >
> > Is there any advantage to this compared to storing dates as strings in
> > (for instance) ISO8601 format?
> >
> > /Johan
