Oracle:
Select To_Char (SYSDATE,'YYYY-MM-DD') "nowDate", To_Char (SYSDATE,'HH24:MI:SS') "nowTime" from dual;
Mysql:
select current_date, current_time,current_timestamp;
参考自:
Oracle:
Select To_Char (SYSDATE,'YYYY-MM-DD') "nowDate", To_Char (SYSDATE,'HH24:MI:SS') "nowTime" from dual;
Mysql:
select current_date, current_time,current_timestamp;
参考自: