From: | "Lonni J Friedman" <netllama(at)gmail(dot)com> |
---|---|
To: | "Michael Glaesemann" <grzm(at)seespotcode(dot)net> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: timestamp interval issue |
Date: | 2007-10-05 23:53:04 |
Message-ID: | 7c1574a90710051653r233922b5j3c56d3d3bc371913@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 10/5/07, Michael Glaesemann <grzm(at)seespotcode(dot)net> wrote:
>
> On Oct 5, 2007, at 18:46 , Lonni J Friedman wrote:
>
> > Thanks. I gave this a try (cut & paste exactly what you provided), but
> > I'm getting a syntax error at the final semicolon?
>
> Ah. I forgot the END of the CASE statement. Give this a try:
>
> select count(date_created)
> from footable0
> where case when current_time < '16:00'::time
> then date_created between (current_date - 1) + interval
> '16 hours'
> and current_date + interval '16 hours'
> else date_created between current_date + interval '16 hours'
> and (current_date + 1) + interval '16
> hours'
> end;
That looks perfect. At least, after a few simple tests its returning
expected results. I'll beat on this some more over the weekend.
I didn't even realize that PostgreSQL supported conditional
statements. Had I known, this would have been alot easier. Guess I
need to RTFM alot more.
Many thanks!
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Glaesemann | 2007-10-05 23:57:37 | Re: timestamp interval issue |
Previous Message | Michael Glaesemann | 2007-10-05 23:48:23 | Re: timestamp interval issue |