SQL:从表中某时间字段获取到当前季度(extract函数) select extract(quarter from current_date) from dual quarter可以求季度,month、year、week可以求月份、年份、第几周信息