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@wolff.to> wrote:
> On Wed, Oct 01, 2003 at 10:26:57 -0700,
>   Theodore Petrosky <tedpet5@yahoo.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