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

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

pgsql-novice by date

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

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