Find day of the Current Week

Very Simple Script which find Day of the Current Week;


SELECT DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0)
Result:
2009-02-09 00:00:00.000 --Day(0) --Monday


SELECT DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 4)
Result:
2009-02-13 00:00:00.000 --Day (4) --Friday
zaman:
Etiketler:

Hiç yorum yok:

Yorum Gönder

Kaydol: Kayıt Yorumları (Atom)

BlackListIP control on Serenity platform (.NET Core)

 In the Serenity platform, if you want to block IPs that belong to people you do not want to come from outside in the .net core web project,...