between Extract(year from :begindate) and Extract(year from :enddate);
截取参数的年份
to_char(add_months(last_day(add_months(STARTDATE, -1)) + 1,
-1),
'yyyy-mm-dd')
-1),
'yyyy-mm-dd')
AND
to_char(last_day(add_months(STARTDATE, -1)), 'yyyy-mm-dd')
to_char(last_day(add_months(STARTDATE, -1)), 'yyyy-mm-dd')
获得上月的第一天和最后天
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24899662/viewspace-679412/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24899662/viewspace-679412/