Re: [GENERAL] Current Year

[Peter Eisentraut]

Hunter Hillegas writes:

> I have an HTML form that submits to Postgre 7.1 beta 4 and I'm wondering how
> to get the current year from the database...

select extract(year from current_date);

> Also, is there a good reference to the PostgreSQL function library? I've
> looked around and can't seem to find one.

http://www.postgresql.org/users-lounge/docs/7.0/user/functions.htm

-- 
Peter Eisentraut      [EMAIL PROTECTED]       http://yi.org/peter-e/