select to_char(trunc(add_months(last_day(sysdate), -1) + 1),
'yyyy-mm-dd') "本月第一天",
to_char(last_day(sysdate), 'yyyy-mm-dd') "本月最后一天"
TO_DATE格式(以时间:2007-11-02 13:45:25为例)
1. 日期和字符转换函数用法(to_date,to_char)
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')
select to_char(sysdate,'dd')
as nowMonth from dual; //获取时间的月
as nowDay from dual;//获取时间的日
select to_char(sysdate,'hh24') as nowHour from dual;//获取时间的时
select to_char(sysdate,'mi') as nowMinute from dual;//获取时间的分
select to_char(sysdate,'ss') as nowSecond from dual;//获取时间的秒
select to_date('2016-3-25 10:44:30','yyyy-mm-dd hh24:mi:ss') from dual
select distinct t.biz_dat,to_char(t.biz_dat,'yyyy-mm-dd') from
ORG_GEN_ACCT_DAY t
select distinct t.biz_dat, to_char(t.biz_dat, 'yyyy-mm-dd')
from ORG_GEN_ACCT_DAY t
where t.biz_dat between to_date('2014-11-1', 'yyyy-mm-dd') and
to_date('2015-12-31', 'yyyy-mm-dd')
select months_between(to_date('2015-12-31', 'YYYY-MM-DD'),
to_dat'e2(014-11-1', 'YYYY-MM-DD')) MONTHS
FROM DUAL;