SELECT DATENAME(dw, DATEADD(dd, – DATEPART(dd, GETDATE()) + 1, GETDAT

Write a SQL Query to find first Week Day of month?

Question Posted / vijay

Answer Posted / vijay

SELECT DATENAME(dw, DATEADD(dd, – DATEPART(dd, GETDATE()) + 1, GETDATE())) AS FirstDay

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the parts of a function?

990

explain different levels of normalization? : Sql server database administration

1050

How to connect to SQL Azure Database by using sqlcmd?

140

What is BLOCK statements in SQL?

1311

How to change the ownership of a schema in ms sql server?

1258

How to convert a unicode strings to non-unicode strings?

1158

What is a group function explain with an example?

1040

Where is trigger in sql server?

1105

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1126

What is format parameter in ssrs?

150

What is identity?

1081

How to recover from sql injection? : sql server security

1067

What are various aggregate functions that are available?

1042

between cast and convert which function would you prefer and why?

1015

What is reference section?

1057