From: Markus Fischer <mfischer@josefine.ben.tuwien.ac.at>
To: pgsql-sql@postgresql.org
Subject: Comparing dates
Date: Tue, 6 Mar 2001 13:33:23 +0100
Message-ID: <20010306133323.A3880@josefine.ben.tuwien.ac.at> (raw)
Hello,
I've a SELECT statement on many joined Tabled and one of them has
a date column called 'date_date'. When I fetch a date e.g.
'02-03-2001', I get, say, 60 results back. When I now perform the
same query with another date, lets take '03-03-2001', I get back
about 70 results.
When I now modify my query to get both results in one I write
SELECT
....
FROM
..
AND
date_date >= '2001-03-02'
AND
date_date <= '2001-03-03'
AND
....
I think I should get back the rows for both days, 60 + 70 makes
130 to me. But what I get back is even smaller then 60. I
allready tried TO_DATE conversion, an OR construct but always
the same result.
Is there something special to know when comparing/working with
date-datetypes ?
kind regards,
Markus
--
Markus Fischer, http://josefine.ben.tuwien.ac.at/~mfischer/
EMail: mfischer@josefine.ben.tuwien.ac.at
PGP Public Key: http://josefine.ben.tuwien.ac.at/~mfischer/C2272BD0.asc
PGP Fingerprint: D3B0 DD4F E12B F911 3CE1 C2B5 D674 B445 C227 2BD0
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mfischer@josefine.ben.tuwien.ac.at
Subject: Re: Comparing dates
In-Reply-To: <20010306133323.A3880@josefine.ben.tuwien.ac.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox