Hi!! I am using postgresql 7.3 and I have a table with one timestamp without zone field (date1), I want to select any row when "date1" is between inicial_date and final_date values, I'm using an Sql sentence like this:
SELECT name, date1, ......
WHERE date1>=inicial_date and date1<=final_date
it works fine if month of field "date1" is the same in "inicial_date" and "final_date", but if month value of "date1" is different the result is always NULL, any idea??????
please help me!!!
pgsql-novice by date
|Next:||From: henlin||Date: 2007-04-25 09:08:15|
|Subject: delete non-unique|
|Previous:||From: A. Kretschmer||Date: 2007-04-24 18:56:13|
|Subject: Re: File I/O|