Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Lonni J FriedmanDate: 2007-10-05 23:46:37
Subject: Re: timestamp interval issue
Previous:From: Michael GlaesemannDate: 2007-10-05 23:37:21
Subject: Re: timestamp interval issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group