Re: timestamp interval issue
| От | Valentin Gjorgjioski |
|---|---|
| Тема | Re: timestamp interval issue |
| Дата | |
| Msg-id | 47076D36.6020407@mt.net.mk обсуждение исходный текст |
| Ответ на | Re: timestamp interval issue (Michael Glaesemann <grzm@seespotcode.net>) |
| Ответы |
Re: timestamp interval issue
|
| Список | pgsql-novice |
On 06.10.2007 01:37 Michael Glaesemann wrote:
>
> On Oct 5, 2007, at 18:08 , Valentin Gjorgjioski wrote:
>
>> where ((now>today:16:00 && date_created>today:16:00) ||
>> (now<today:16:00 && date_created>yesterday:16:00))
>
> I assume he wanted SQL: what language is this?
>
ok, here it is ... I was not expecting that writing sql will be a problem...
where
(
now()>('today'::timestamp+interval '16 hours')
AND
date_created>('today'::timestamp+interval '16 hours')
)
OR
(
now()<('today'::timestamp+interval '16 hours')
AND
date_created>('today'::timestamp+interval '16 hours')
)
В списке pgsql-novice по дате отправления: