Re: [sqlite] datetime as integer

John Machin writes: > > > "noon in Greenwich on November 24, 4714 BC" - > > presumably that's the beginning of time for Creationists ... > > You presume incorrectly; it's the start of Scaliger's 7980-year "Julian" > astronomical cycle.

Re: [sqlite] datetime as integer

On 17/03/2009 1:00 AM, MikeW wrote: > Timothy A. Sawyer writes: > [snip] >> For date calculations, SQLite prefers real values containing >> number of days since noon in Greenwich on November 24, 4714 >> B.C., using the Proleptic Gregorian calendar: > SNIP > > "noon in Greenwich on

Re: [sqlite] datetime as integer

know that baseline value >> --Original Message-- >> From: Kees Nuyt >> Sender: sqlite-users-boun...@... >> To: sqlite-us...@... >> ReplyTo: sqlite-us...@... >> Sent: Mar 13, 2009 14:58 >> Subject: Re: [sqlite] datetime as integer >> >> Just

Re: [sqlite] datetime as integer

g of time) >> and you must know that baseline value >> --Original Message-- >> From: Kees Nuyt >> Sender: sqlite-users-boun...@... >> To: sqlite-us...@... >> ReplyTo: sqlite-us...@... >> Sent: Mar 13, 2009 14:58 >> Subject: Re: [sqlite] datetime as

Re: [sqlite] datetime as integer

Nuyt > Sender: sqlite-users-boun...@... > To: sqlite-us...@... > ReplyTo: sqlite-us...@... > Sent: Mar 13, 2009 14:58 > Subject: Re: [sqlite] datetime as integer > > Just a few corrections. > SNIP > For date calculations, SQLite prefers real values containing > number o

Re: [sqlite] datetime as integer

: sqlite-users@sqlite.org Sent: Mar 13, 2009 14:58 Subject: Re: [sqlite] datetime as integer Just a few corrections. On Fri, 13 Mar 2009 13:48:46 +, "Timothy A. Sawyer" <tsaw...@mybowlingdiary.com> wrote: >To be able to do this you need the following data points: > &

Re: [sqlite] datetime as integer

-boun...@sqlite.org] On Behalf Of Kees Nuyt Sent: Friday, March 13, 2009 2:58 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] datetime as integer Just a few corrections. On Fri, 13 Mar 2009 13:48:46 +, "Timothy A. Sawyer" <tsaw...@mybowlingdiary.com> wrote: >To be able

Re: [sqlite] datetime as integer

2009/3/13 John Machin : > On 12/03/2009 12:21 AM, Nicolás Solá wrote: >> Hi I’m using Trac software and it is implemented using SQLITE3. In Trac DB >> schema there is a table called “milestone”. It has a field called “due” and >> it means due date. The problem is that it uses

Re: [sqlite] datetime as integer

On 12/03/2009 12:21 AM, Nicolás Solá wrote: > Hi I’m using Trac software and it is implemented using SQLITE3. In Trac DB > schema there is a table called “milestone”. It has a field called “due” and > it means due date. The problem is that it uses an integer data type to store > the datum and I