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(at)gmx(dot)net http://funkturm.homeip.net/~peter