Re: timestamp interval issue

On 06.10.2007 13:10 Valentin Gjorgjioski wrote:
> 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')
> )
There is a little error (last today should be yesterday)
  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>('yesterday'::timestamp+interval '16 hours')
  )