Re: Selecting all records between a date range

From: Date: Wed, 08 Oct 2008 01:16:35 +0000
Subject: Re: Selecting all records between a date range
References: 1 2  Groups: php.general 
Request: Send a blank email to php-general+get-281561@lists.php.net to get a copy of this message
Dan Joseph wrote:
On Thu, Oct 2, 2008 at 12:35 PM, Jason Pruim <japruim@raoset.com> wrote: 
       SQLTEST: SELECT * FROM timeStore WHERE        timein BETWEEN
1222315200 AND 1222920000 Could not perform query: Query was empty <japruim@raoset.com>
Put a ' around your timestamp numbers. I think that should fix that query. Although I'll admitt, I have no way to test that on mysql, but that is how MS SQL works...
Int's don't need quoting in mysql (or postgres, or oracle).. not sure why ms-sql would need that. -- Postgresql & php tutorials http://www.designmagick.com/

« previous php.general (#281561) next »