Re: timestamp interval issue

On 10/5/07, Michael Glaesemann <grzm(at)seespotcode(dot)net> wrote:
>
> On Oct 5, 2007, at 17:47 , Lonni J Friedman wrote:
>
> > I need a means of returning only the rows which have a
> > timestamp that falls after the last 16:00 and before the next 16:00
> > (on the clock), regardless of date.
>
> Would something like this work for you?
>
> select *
> 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';
>
> I'm not sure if I'm interpreting what you need properly, but I think
> this does what you want.

Thanks. I gave this a try (cut & paste exactly what you provided), but
I'm getting a syntax error at the final semicolon?