Re: timestamp interval issue

From: "Lonni J Friedman" <netllama(at)gmail(dot)com>
To: "Michael Glaesemann" <grzm(at)seespotcode(dot)net>
Cc: "Valentin Gjorgjioski" <tinodj(at)mt(dot)net(dot)mk>, pgsql-novice(at)postgresql(dot)org
Subject: Re: timestamp interval issue
Date: 2007-10-05 23:44:15
Message-ID: 7c1574a90710051644p49c3c2fej2c5423c47ee51fc1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 10/5/07, Michael Glaesemann <grzm(at)seespotcode(dot)net> 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?

Yes, I was hoping for SQL. Barring that, I'll like have to hack up
something in PHP to create a different SQL statement based on the time
of day.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Lonni J Friedman 2007-10-05 23:46:37 Re: timestamp interval issue
Previous Message Michael Glaesemann 2007-10-05 23:37:21 Re: timestamp interval issue