select y.*, t.specialty_name
from t_ts_net_activitys y, t_ts_meeting_specialty t
where y.specialty_id = t.specialty_id
and EXTRACT(YEAR FROM TO_DATE(y.activity_date, 'yyyy-MM-dd hh24:mi:ss')) = 2011
and EXTRACT(MONTH FROM TO_DATE(y.activity_date, 'yyyy-MM-dd hh24:mi:ss')) = 10
order by y.activity_date desc
也可以使用oracle的substr函数截取 sunstr(字段,起始位置,结束位置)