Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
MLK Date
declare @check_date datetime, @FirstDayOfYear datetime set @check_date = '01-01-2024' SELECT @FirstDayOfYear = DATEADD(yy, DATEDIFF(yy,0,@check_date) , 0 ) SELECT DATEADD(DAY, 14 , DATEADD(WEEK, DATEDIFF(WEEK, 0, DATEADD(DAY, 6 -DATEPART(DAY, @FirstDayOfYear ), @FirstDayOfYear)),0))
run
|
edit
|
history
|
help
0
EXP 8
2021-03-23_LeetCodeSQL
Sequence object -- New Feature of 2012 sql server
Mass Insert using Except
Terceiro
mc170403050
sqlserver
Shruti
db_hotel29102020
Libros