[MySQL]取得目前時間用法

select now();
'2012-09-24 18:14:11'


select current_date;
'2012-09-24' 

select CURRENT_TIME;
18:15:22 

select CURRENT_TIMESTAMP; 
'2012-09-24 18:16:28'