Sql server gestire le settimane

select   cast(CONVERT(char(10), getdate(), 110) as datetime) [today]

,        datename(dw, getdate()) [day]

,        datepart(dw, getdate()-1) [day of week]

,        datepart(dw, getdate()-1)-1 [days since monday]

,        7-datepart(dw, getdate()-1) [days until sunday]

,        cast(CONVERT(char(10), (getdate()-(datepart(dw, getdate()-1)-1)), 110) as datetime) [monday]

,        cast(CONVERT(char(10), (getdate()+(7-datepart(dw, getdate()-1))), 110) as datetime) [sunday]

 

query utile quando si devono trattare le settimane...

posted @ martedì 1 luglio 2008 07:03

Print
«febbraio»
domlunmarmergiovensab
28293031123
45678910
11121314151617
18192021222324
252627282912
3456789