Re: Selecting all records between a date range

On Tue, Oct 7, 2008 at 9:16 PM, Chris <dmagick@gmail.com> wrote: > 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. > MS SQL doesn't need them for integer values either. I'm not sure why you would want to do that. Andrew