Andre du Plessis wrote:
select date_modified from table where julianday(date_modified) >
julianday(CURRENT_TIMESTAMP) - 1;
this seems to work perfectly, for some reason the function can simply
convert the text successfully, not sure how it's able to do that, but
impressive,
Is there anyway to
Sent: 27 August 2007 11:39 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Date comparison on UTC
If you use the Sqlite floating point number format (function julianday
will do the conversion) you can use functions to compare days and dates.
Andre du Plessis wrote:
I have a UTC date stored
atestamp to the beginning of the day,
or maybe do you know if there is a list of built-in date functions
somewhere?
Thanks.
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: 27 August 2007 11:39 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Date comparison on UTC
If you use the Sqlite floating point number format (function julianday
will do the conversion) you can use functions to compare days and dates.
Andre du Plessis wrote:
I have a UTC date stored in text column in this format:
2007-08-27 08:58:16.601000
I want to do some selects for all
I have a UTC date stored in text column in this format:
2007-08-27 08:58:16.601000
I want to do some selects for all that is newer than one day for
example, or then all that is older than 1 month, etc,
Any ideas?
Thanks.
5 matches
Mail list logo