Re: SQL and function reference?

From: "Rodolfo J(dot) Paiz" <rpaiz(at)simpaticus(dot)com>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: Alexander Borkowski <alexander(dot)borkowski(at)abri(dot)une(dot)edu(dot)au>, pgsql-novice(at)postgresql(dot)org
Subject: Re: SQL and function reference?
Date: 2005-01-26 16:58:35
Message-ID: 1106758715.5295.53.camel@rodolfo.gt.factorrent.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Wed, 2005-01-26 at 10:39 -0600, Rodolfo J. Paiz wrote:
> The idea here is to have a formula that says "select * from flights
> where date was less than 30 days ago" and have that formula work
> properly. So if I want to subtract two dates for this purpose, then I am
> going to need a today() function which I also have not found.
>

Silly me: current_date(). <smile>

Cheers,

--
Rodolfo J. Paiz <rpaiz(at)simpaticus(dot)com>

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Rodolfo J. Paiz 2005-01-26 17:18:01 Re: Formatting a month in query output
Previous Message Rodolfo J. Paiz 2005-01-26 16:39:41 Re: SQL and function reference?