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')
)