select now（）

方法一：select current_timestamp() from dual;

方法二：select current_time() from dual;

方法三：select current_date() from dual;

方法四：select curdate() from dual;

方法五：select curtime() from dual;

如果能帮到您，麻烦您点下采纳，谢谢！