Re: SQL and function reference? - Mailing list pgsql-novice

From Rodolfo J. Paiz
Subject Re: SQL and function reference?
Date
Msg-id 1106758715.5295.53.camel@rodolfo.gt.factorrent.com
Whole thread Raw
In response to Re: SQL and function reference?  ("Rodolfo J. Paiz" <rpaiz@simpaticus.com>)
List 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@simpaticus.com>


pgsql-novice by date:

Previous
From: "Rodolfo J. Paiz"
Date:
Subject: Re: SQL and function reference?
Next
From: "Rodolfo J. Paiz"
Date:
Subject: Re: Formatting a month in query output