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. (http://en.wikipedia.org/wiki/Julian_day#History)
>
> You a
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 November 24,
gt; --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 a few corrections.
>&
aseline 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 a few correc
ender: 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 of days since noon
: 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"
wrote:
>To be able to do this you need the following data points:
>
>1. What is the integer representation o
-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"
wrote:
>To be able to do this you need the followin
You could of course just try this and see what happens:
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-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"
wrote:
>To be able to do this you need the following data points:
>
>1. What is the integer representation of the date?
> Is it days or seconds from a certain date?
> Keep in mind that 1 day = 86400 seconds = 3
On 14/03/2009 12:48 AM, Timothy A. Sawyer wrote:
> Most date representations are stored as seconds since 1-1-1970 depending on
> the underlying OS
This applies (fortunately) only to applications whose use for a date is
related to unix-alike filesystems and nothing much else ... imagine a
passp
re using C (or a variant) or
Java there are functions that will do this for you.
--Original Message--
From: Nicolás Solá
Sender: sqlite-users-boun...@sqlite.org
To: sqlite-users@sqlite.org
ReplyTo: General Discussion of SQLite Database
Sent: Mar 11, 2009 09:21
Subject: [sqlite] datetime
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 an integer data type t
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 don
Hi Im 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 dont know how to show it in a SELECT query as datetime
14 matches
Mail list logo