Yea do a search on the mysql.com web site for date functions (or just
click here http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html )
its loaded with many examples and descriptions of useful functions.
Built in date calculations are one thing I really enjoy with mysql.
Best,
Yoed
To get the current year, use:
SELECT DATE_FORMAT(NOW(), '%Y');
Basically you can use the DATE_FORMAT to show the present time as
desired.
--bmansell
-Original Message-
From: Greg Hosler [mailto:[EMAIL PROTECTED]
Sent: Friday, April 23, 2004 5:08 PM
To: [EMAIL PROTECTED]