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.
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
>
--
Cory Nelson
http://www.int64.org
