17,377
社区成员
发帖
与我相关
我的任务
分享
v_begintime := to_date(add_months(sysdate,-1)||' 00:00:00','yyyymmdd hh24:mi:ss');
SQL>
SQL> SELECT 1
2 FROM dual
3 WHERE trunc(add_months(SYSDATE, -1), 'mm') = to_date('2010-07-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss');
1
----------
1
SQL>
v_begintime :=trunc(add_months(SYSDATE,-1),'mm');
v_begintime :=SELECT trunc(add_months(SYSDATE,-1),'mm') FROM dual;
SELECT trunc(add_months(SYSDATE,-1),'mm') FROM dual;