Re: is this my date problem

I am sorry, I wasn't clear... when i refered to

01 October 2003

I got zero results. I only got results for the October
1 date when i refered to it as september 31....

I am on 7.3.4 on OS X

Ted

--- Bruno Wolff III <bruno(at)wolff(dot)to> wrote:
> 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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

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