写法一.
select * from tablename where to_char(create_time,'YYYY-MM') ='2008-01'
写法二.
select * from tablename where create_time>=to_date('2008-01-01
00:00:00','YYYY-MM-DD HH24:MI:SS')
and create_time<=last_day(to_date('2008-01-01 00:00:00','YYYY-MM-DD
HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS') ;
后一种写法效率高
last_day 返回特定日期所在月份的最后一天
SELECT to_date(to_char(SYSDATE,'yyyy')||'-01-01','yyyy-mm-dd' ) FROM dual
用 || 进行字符串连接