Re: [sqlite] SQL Lite date / time functions

2009-09-24 Thread Alexey Pechnikov
Hello! On Thursday 24 September 2009 05:54:12 Dan Bishop wrote: > > 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

Re: [sqlite] SQL Lite date / time functions

2009-09-23 Thread Dan Bishop
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 >>

Re: [sqlite] SQL Lite date / time functions

2009-09-23 Thread Alexey Pechnikov
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

Re: [sqlite] SQL Lite date / time functions

2009-09-21 Thread Igor Tandetnik
Alexey Pechnikov 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

Re: [sqlite] SQL Lite date / time functions

2009-09-21 Thread Alexey Pechnikov
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

Re: [sqlite] SQL Lite date / time functions

2009-09-21 Thread Igor Tandetnik
Alexey Pechnikov 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. > Does SQLite now uses internal reprezentation of > microseconds

Re: [sqlite] SQL Lite date / time functions

2009-09-21 Thread Alexey Pechnikov
Hello! On Monday 21 September 2009 05:44:31 D. Richard Hipp wrote: > Is the content of the "date" field either a julian day number or an > ISO-8601 format date string? Please speak is now correct to store 'start of month' dates in julianday format? Does SQLite now uses internal reprezentation

Re: [sqlite] SQL Lite date / time functions

2009-09-20 Thread D. Richard Hipp
On Sep 18, 2009, at 7:59 PM, Mike Nolting wrote: > Mr Hipp > > I am unable to make any of the date time functions work using your > examples on your web site when applying to > data in a table. > The 'now' variable works great, but there seems to be no way to use > data from a select query