is this my date problem

I am not sure but i thought I read something of this
problem and maybe its not a problem but my
understanding.

There are only 30 days in september however I can not
seem to make a query that asks for october 1.

proofduedate is  time stamp with zone
maybe this is the problem but I am a little lost.


SELECT jobnumseq, proofduedate FROM jobs WHERE
proofduedate BETWEEN to_timestamp('29 September 2003',
'DD Month YYYY') AND to_timestamp('31 September 2003
23:59', 'DD Month YYYY HH24:MI');
 jobnumseq |      proofduedate
-----------+------------------------
     10080 | 2003-09-30 17:00:00-04
     10081 | 2003-09-30 22:00:00-04
     10082 | 2003-10-01 16:00:00-04
     10074 | 2003-09-29 16:00:00-04
     10077 | 2003-09-29 16:00:00-04
     10078 | 2003-09-29 18:00:00-04
     10079 | 2003-09-30 15:00:00-04
     10083 | 2003-10-01 13:00:00-04
     10084 | 2003-10-01 13:00:00-04
     10085 | 2003-10-01 13:00:00-04
     10086 | 2003-10-01 16:00:00-04
     10087 | 2003-10-01 16:00:00-04
     10088 | 2003-10-01 16:00:00-04
(13 rows)


Ted

__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com