Datetime sql server week

Sql server week number

datepart(wk, DateToParse)

Source: grepper.com

Sql server get week dates from week number

SELECT  
	DATEADD(DAY, 2 - DATEPART(WEEKDAY, GETDATE()), CAST(GETDATE() AS DATE)) [Week_Start_Date],  
	DATEADD(DAY, 8 - DATEPART(WEEKDAY, GETDATE()), CAST(GETDATE() AS DATE)) [Week_End_Date]

-2

Source: c-sharpcorner.com

Similar codes

0 vote142 views1 answer
Check if table exists oracle
SQL
2 votes172 views1 answer
Revokeprivileges mysql
SQL
0 vote143 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote142 views1 answer
Nth max in my sql
SQL
0 vote144 views1 answer
Why we have to set the password for my sql server
SQL
0 vote153 views1 answer
Declare or use variable in snowflake
SQL
0 vote131 views1 answer
Duplicate foreign key constraint name
SQL
-1 vote148 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote136 views1 answer
Mysql percentage of total
SQL
11 votes137 views2 answers
Having clause
SQL