SQL> select to_char(sysdate,'yyyy') from dual;TO_C
----
2005SQL> select to_char(sysdate,'mm') from dual;TO
--
06SQL> select to_char(sysdate,'dd') from dual;TO
--
03SQL> select to_char(sysdate,'hh24') from dual;TO
--
15SQL> select to_char(sysdate,'mi') from dual;TO
--
56SQL> select to_char(sysdate,'ss') from dual;TO
--
02
----
2005SQL> select to_char(sysdate,'mm') from dual;TO
--
06SQL> select to_char(sysdate,'dd') from dual;TO
--
03SQL> select to_char(sysdate,'hh24') from dual;TO
--
15SQL> select to_char(sysdate,'mi') from dual;TO
--
56SQL> select to_char(sysdate,'ss') from dual;TO
--
02
( { { YEAR
| MONTH
| DAY
| HOUR
| MINUTE
| SECOND
}
| { TIMEZONE_HOUR
| TIMEZONE_MINUTE
}
| { TIMEZONE_REGION
| TIMEZONE_ABBR
}
}
FROM { datetime_value_expression | interval_value_expression }
)例如:
select extract(year from sysdate) from dual
2005我这里year,month,day都可以用,但hour,minute,second不能用,不知道怎么回事