Hello!
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');
Equal condition for dates is work now but is it safety?
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
