|| 用于拼接 等同于 concat()
select extract(year from sysdate)-1 from dual
select extract(year from sysdate)-1||'-01-01 00:00:00' start_time from dual;
select concat(extract(year from sysdate) -1||'-12-'||to_char(LAST_DAY(sysdate),'dd '),'23:59:59') end_time from dual;
extract()
- 从oracle 9i中引入,用于从一个date或者interval类型中截取到特定的部分
- 一般用于日期截取
--yesterday / gestern
select to_char(to_date(to_char(sysdate