Hello!
On Monday 21 September 2009 19:56:07 Igor Tandetnik wrote:
> > Are correct selects like as
> > SELECT * from tbl_name where date = julianday('now','start of month');
>
> I see no reason why not. Note that the condition will only hold when
> "date" column represents midnight on the corresponding day.
>
> > Equal condition for dates is work now but is it safety?
>
> In general, comparing double values for exact equality is risky.
> However, fractions that are powers of two are represented exactly in a
> double, so the comparison would work for values that represent, for
> example, 3, 6, 9 and 12 o'clock (both AM and PM).
Can you add this note to documentation? This is very speculate question.
Especially because internal SQLite representation of julianday was chanded
some times ago.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
