Thread: Current Year
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... Basically they are entering dates but all I want them to have to enter is the month and the day of the month and then get the current year from the DB and programmatically fuse them together... Also, is there a good reference to the PostgreSQL function library? I've looked around and can't seem to find one. Thanks, Hunter -- Hunter Hillegas hunter@lastonepicked.com
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 peter_e@gmx.net http://yi.org/peter-e/