Alexey Pechnikov wrote:
> 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.
It's not a date-specific issue; the same thing occurs with ordinary numbers.
sqlite> select (1.0/49)*49 = 1.0;
0
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
