SQL日期查询技巧：按月份筛选数据与获取当前日期信息

sql如何按日期中的月份查询

select*from表名wheredatepart(dd,时间字段)=待查询日期的天数anddatepart(mm,时间字段)=待查询月份例如有表t_cp时间字段stimeselect*fromt_cpwheredatepart(dd,stime)=5anddatepart(mm,stime)=8查询该表8月5日的数据。

SQL中查询日期语句

selectgetdate()作为日期，年份(getdate())作为年份，casemonth(getdate())when1then'一月'when2then'二月'when3then'三月'when4then'四月'when5then'五月'when6then'六月'when7then'七月'when8then'八月'when9then'九月'when10then'十月'when11then'十一月'when12then'102个月结束，casedatepart(weekday,getdate())-1when1then'Monday'when2then'Tuesday'when3then'Wednesday'when4then'Thursday'when5then'Friday'when6then'Saturday'when0then'Sunday'Week，datepart(week,getdate())作为一年中的第几周，datepart(quarter,getdate())作为一年中的季度