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

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

Question Posted / saravakumar

Answer Posted / saravakumar

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

Is This Answer Correct ?

31 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Other than truncate statement, which other command can by-pass the trigger on the tables?

1134

What is tcl in sql server?

1126

What is open database communication (odbc)?

1063

What are scalar functions?

1000

How to execute a stored procedure in ms sql server?

1178

can a table be moved to different filegroup? : Sql server administration

979

What is user-defined scalar function?

969

How to select some specific columns from a table in a query in ms sql server?

1005

Is t sql the same as sql server?

977

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1059

What are four major operators that can be used to combine conditions on a where clause?

1054

What are the requirements to use odbc connections in php scripts?

1120

Do you know what is a linked server in sql server?

1025

Which sql server is best?

996

How to create indexed view?

1045