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

[sprite18]

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

[小李木耳]

Substr(xxx,1,4)

[项目管理传播者]

表 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

[dashi]

up~~~

[tgm78]

SQL> select to_char(sysdate,'YYYY') from dual;

TO_CHAR(SYSDATE,'YYYY')
-----------------------
2007

[wanglark]

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

TO_C
----
2007

[junval]

SQL> select to_char(sysdate,'YYYY') from dual;

TO_CHAR(SYSDATE,'YYYY')
-----------------------
2007

[skystar99047]

to_char(datefield,'yyyy')