Re: Date manipulation - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Date manipulation
Date
Msg-id Pine.LNX.4.30.0105312307290.757-100000@peter.localdomain
Whole thread Raw
In response to Date manipulation  (Mark <mark@zserve.com>)
List pgsql-sql
Mark writes:

> I have a query that determines the number of days that are between now
> and a particular date that looks something like this:
>
> select datediff (dd, now (), column) as difference_in_days from ...
>
> Anything available short of coding my own function?

select date 'particular date' - current_date;

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



pgsql-sql by date:

Previous
From: Mark
Date:
Subject: Date manipulation
Next
From: Gerald Gutierrez
Date:
Subject: RE: primary key scans in sequence