select * from this_table where to_char(this_table.rcddate,'YYYY')= 2006
yyyy,这么古怪,那要是月呢,mmmm?天呢? yyyy-mmmm-dddd??????????
查询为2006年的纪录 select * from this_table where to_char(this_table.rcddate,'YYYY')= '2006'查询为200608月份的纪录 select * from this_table where to_char(this_table.rcddate,'YYYYMM')= '200608'查询为20060831月份的纪录 select * from this_table where to_char(this_table.rcddate,'YYYYMMDD')= '20060831'
yyyy-mmmm-dddd??????????
select * from this_table where to_char(this_table.rcddate,'YYYY')= '2006'查询为200608月份的纪录
select * from this_table where to_char(this_table.rcddate,'YYYYMM')= '200608'查询为20060831月份的纪录
select * from this_table where to_char(this_table.rcddate,'YYYYMMDD')= '20060831'