SQL语句怎么查周六周天答:用getdate()可以得到每个星期天,sql查询语句select DATEADD(wk, DATEDIFF(wk,0, dateadd(dd,6-datepart(day,getdate()),getdate()) ), -1)union all select DATEADD(wk, DATEDIFF(wk,0, dateadd(dd,6-datepart(day,getdate()),getdate()) ), 6)union all select DATEADD(wk, DATEDIFF(...
在sql中怎样获得已知日期是星期几答:Oracle数据库:第一个:SELECT DECODE(dw,0,'星期天',1,'星期一',2,'星期二',3,'星期三',4,'星期四',5,'星期五',6,'星期六') WEEK_DAY FROM (SELECT 7 - TO_NUMBER(NEXT_DAY(TO_DATE('2012-12-12', 'yyyy-mm-dd'), 1) - TO_DATE('2012-12-12', 'yyyy-mm-dd')) dw...