MySQL获取当前时间

获取当前时间年月日时分秒：

select now() from dual;
select current_timestamp() from dual;

 

获得当前时间年月日:

select CURRENT_DATE() from dual;
select curdate() from dual;

 

获取当前时分秒:

select current_time() from dual;
select curtime() from dual;