同样的语句执行结果不同:
SQL> select last_day(add_months(sysdate,-1))+1 l from dual;
L
-----------
2011-11-1 2SQL> select last_day(add_months(sysdate,-1))+1 from dual;
LAST_DAY(ADD_MONTHS(SYSDATE,-1
------------------------------
2011-11-1 20:06:24
为什么加了列别名后在命令窗口下执行结果会不一样呢?
SQL> select last_day(add_months(sysdate,-1))+1 l from dual;
L
-----------
2011-11-1 2SQL> select last_day(add_months(sysdate,-1))+1 from dual;
LAST_DAY(ADD_MONTHS(SYSDATE,-1
------------------------------
2011-11-1 20:06:24
为什么加了列别名后在命令窗口下执行结果会不一样呢?
SQL> select last_day(add_months(sysdate,-1))+1 l from dual;L
---------
01-NOV-11SQL> select last_day(add_months(sysdate,-1))+1 from dual;LAST_DAY(
---------
01-NOV-11你上面那个加别名,好像没显示全
查询结果是date,你可以用to_char转换以后再显示,就一样了
SQL> select to_char(last_day(add_months(sysdate,-1))+1,'yyyy-mm-dd hh24:mi:ss') from dual;
TO_CHAR(LAST_DAY(ADD_MONTHS(SY
------------------------------
2011-11-01 17:36:41
SQL> select to_char(last_day(add_months(sysdate,-1))+1,'yyyy-mm-dd hh24:mi:ss') l from dual;
L
-------------------
2011-11-01 17:36:50
L
-----------
2011/11/1 1
SQL> select last_day(add_months(sysdate,-1))+1 from dual;
LAST_DAY(ADD_MONTHS(SYSDATE,-1
------------------------------
2011/11/1 18:16:53
我也是这个问题
SQL> select last_day(add_months(sysdate,-1))+1 l from dual;
L
-----------
2011/11/1 1
SQL> select last_day(add_months(sysdate,-1))+1 from dual;
LAST_DAY(ADD_MONTHS(SYSDATE,-1
------------------------------
2011/11/1 18:19:03
SQL> select last_day(add_months(sysdate,-1))+1 qqqqqqqqqqqqqqqqqqqq from dual;
QQQQQQQQQQQQQQQQQQQQ
--------------------
2011/11/1 18:19:11