Skip site navigation (1) Skip section navigation (2)

Re: timestamp interval issue

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: "Lonni J Friedman" <netllama(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: timestamp interval issue
Date: 2007-10-05 23:35:01
Message-ID: 822A4F4F-1D2C-4D67-99E8-14E5A554E5EE@seespotcode.net (view raw or flat)
Thread:
Lists: pgsql-novice
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.

Michael Glaesemann
grzm seespotcode net



In response to

Responses

pgsql-novice by date

Next:From: Michael GlaesemannDate: 2007-10-05 23:37:21
Subject: Re: timestamp interval issue
Previous:From: Lonni J FriedmanDate: 2007-10-05 23:33:01
Subject: Re: timestamp interval issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group