Alexey Pechnikov <[email protected]> wrote: > On Monday 21 September 2009 15:59:47 Igor Tandetnik wrote: >>> Please speak is now correct to store 'start of month' dates in >>> julianday format? >> >> Was it at some point "incorrect" to do so? Yes, you can store any >> date in julian day format, start of month or otherwise. > > 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). Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
