Date Variables/Functions
These functions are reliable assuming the computers clock is set correctly
curdate()+0 returns date in form char yyyymmdd e.g. 20040131
year(now()) returns year in form dec yyyy e.g. 2005
curtime() returns time in form char hh:mm:ss e.g. 03:10:35
date_format(date, format) allows you to specify how you want to see
the date - there are many format codes - see
them all in the MySQL manual
Linux/MySql/Funktionen/DateTime (last modified 2008-11-04 07:00:04)