能否用select语句获得日期类型字段的年份?不显示月,日

Question

能否用select语句获得日期类型字段的年份?不显示月,日

Answer 1

表 tab;
字段 adddate date
select t.adddate from tab t
1 2007-3-15 14:30:21
2 2007-3-15 14:30:47
3 2007-3-15 14:40:01
4 2007-3-15 14:34:16
5 2007-3-15 14:38:16
6 2007-3-15 14:35:12
7 2007-3-15 14:57:55
8 2007-3-5
select to_char(t.adddate,'yyyy-mm-dd') from tab t
1 2007-03-15
2 2007-03-15
3 2007-03-15
4 2007-03-15
5 2007-03-15
6 2007-03-15
7 2007-03-15
8 2007-03-05
select substr(to_char(t.adddate,'yyyy-mm-dd'),1,4) from tab t
1 2007
2 2007
3 2007
4 2007
5 2007
6 2007
7 2007
8 2007

Answer 2

SQL> select to_char(sysdate,'YYYY') from dual;TO_CHAR(SYSDATE,'YYYY')
-----------------------
2007

Answer 3

SQL> select to_char(sysdate,'YYYY') from dual;TO_CHAR(SYSDATE,'YYYY')
-----------------------
2007

Answer 4

SQL> select to_char(sysdate,'yyyy') from dual;TO_C
----
2007