Re: [sqlite] Date comparison on UTC

2007-08-27 Thread Dennis Cote
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

Re: [sqlite] Date comparison on UTC

2007-08-27 Thread John Stanton
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

RE: [sqlite] Date comparison on UTC

2007-08-27 Thread Andre du Plessis
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

Re: [sqlite] Date comparison on UTC

2007-08-27 Thread John Stanton
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