oracle中to_date詳細用法示例(oracle日期格式轉換)_oracle_腳本之家
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') as nowTime from dual; //日期轉化為字元串 select to_char(sysdate,'yyyy') as nowYear from dual; //獲取時間的年 select to_char(sysdate,'mm') as nowMonth from dual; //獲取時間的月 select to_char ......