to yangtingkun
用to_char(sssq_q,'yyyy')后结果与substr(to_char(sssq_q,'yyyymmdd'),1,4)的结果一样,都是'0000'。
SQL> desc sb_zzs_2003_fb;
Name Type Nullable Default Comments
----------- ------------ -------- ------- --------
FBXH CHAR(16)
FBLX CHAR(3)
PZXH CHAR(16)
NSRSBH VARCHAR2(20)
SBRQ DATE Y
TBRQ DATE Y
SSSQ_Q DATE
SSSQ_Z DATE
NSR_SWJG_DM CHAR(11)
SWJG_DM CHAR(11)
LRR_DM CHAR(11)
LRRQ DATE
XGR_DM CHAR(11)
XGRQ DATE
CSBZ_S CHAR(1)
CSBZ_X CHAR(1)
to DemonSam
SQL> select to_char(sssq_q,'yyyymmdd') sssq_q_year,sssq_q from sb_zzs_2003_fb where sssq_q>to_date('20040101','yyyymmdd') and rownum<10;
SSSQ_Q_YEAR SSSQ_Q
----------- -----------
00000000 2004-2-1
00000000 2004-2-1
00000000 2004-2-1
00000000 2004-2-1
00000000 2004-2-1
00000000 2004-2-1
00000000 2004-2-1
00000000 2004-2-1
00000000 2004-2-1
9 rows selected
Executed in 0.02 seconds