Re: is this my date problem

On Wed, Oct 01, 2003 at 10:26:57 -0700,
Theodore Petrosky <tedpet5(at)yahoo(dot)com> wrote:
> 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.

You shouldn't be refering to September 31 as that isn't a valid date.
>From your output it looks like it may have been treated as the same
as October 1, but I wouldn't count on that working in the future.

>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings