Thread: How to compare Datetime

How to compare Datetime

From
Henrik Pedersen
Date:
Hi...

Im having some problems with the datetime fields

Here is an example:+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| id                               | int4                             |     4 |
| fornavn                          | text                             |   var |
| tilmelddato                      | datetime                         |     8 |
+----------------------------------+----------------------------------+-------+

I want to select the entries that came in to the database 15 days ago.
tilmelddato contains the date that the entry was entered.


I do a "select * from testtable where tilmelddato = '01/04/1999'"
but that doesn't return anything even though my database contains
2 entries for that day.

If a do a "select * from testtable where tilmelddato > '01/04/1999'" it
returns 6 hits, but 2 of the hits was entered on the 01/04/1999 and
should not be in there, because of the >.

But if i use the < sign it works as i should. But if i do this:
"Select * from testtable where tilmelddato <= '15/04/1999'" the records
with 15/04/1999 is NOT included in the result set.


Im a bit confused about this .. the = dosnt work, the > and < works
partly

                                                                                                            
Im running Redhat 5.2 with kernel 2.2.4 and postgresql-6.4.2

Hope someone out there knows the answer :)

With friendly regards

Henrik Pedersen
Denmark