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
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
>>
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
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
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
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
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
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
8 matches
Mail list logo