oracle系统的当前时间
select sysdate from dual;
oracle系统的当前时间,年、月、日
select to_char(sysdate,'yyyy') from dual;
select to_char(sysdate,'mm') from dual;
select to_char(sysdate,'dd') from dual;
oracle系统的当前时间
select sysdate from dual;
oracle系统的当前时间,年、月、日
select to_char(sysdate,'yyyy') from dual;
select to_char(sysdate,'mm') from dual;
select to_char(sysdate,'dd') from dual;