From: | Nis Jørgensen <nis(at)superlativ(dot)dk> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: timestamp interval issue |
Date: | 2007-10-08 10:46:06 |
Message-ID: | fed1pi$lhh$1@sea.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Lonni J Friedman skrev:
> Greetings,
> I've got an interesting problem. I have a table with a column full of
> timestamps. 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.
>
> For example, let's say I've got this in my table:
>
> date_created
> ----------------------
> 10-05-2007 00:44:45
> 10-04-2007 17:59:43
> 10-04-2007 19:12:00
> 10-04-2007 17:59:54
> 10-03-2007 21:00:56
> 10-04-2007 19:12:00
> 10-03-2007 21:00:58
>
> and let's say that the current timestamp (select now()) returns:
> 2007-10-05 15:18:54.133368-07
>
> I need to get back just the following rows:
> 10-05-2007 00:44:45
> 10-04-2007 17:59:43
> 10-04-2007 19:12:00
> 10-04-2007 17:59:54
> 10-04-2007 19:12:00
Something like this?
SELECT *
FROM footable0
WHERE (date_created - interval '16 hours')::date = (now() - interval '16
hours')::date;
Tested.
Nis
From | Date | Subject | |
---|---|---|---|
Next Message | Nis Jørgensen | 2007-10-08 11:14:59 | Re: timestamp interval issue |
Previous Message | Valentin Gjorgjioski | 2007-10-06 11:16:18 | Re: timestamp interval issue |