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

What is normalization of database?

1180

Explain DBCC?

1016

what is the system function to get the current user's user id? : Sql server database administration

1073

How to encrypt Strored Procedure in SQL SERVER?

1229

Tell me about normalization in DBMS.

1064

Explain intellisense for query editing

1076

How to replace null values in expressions using isnull()?

1152

Do I need a report server to run reports in my application?

170

What are drillthrough reports?

161

What are the properties of the transaction?

1052

Define candidate key, alternate key, and composite key.

969

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

1043

What are data resources?

965

How to maintain a fill factor in existing indexes?

1057

How many levels of sp nesting are possible?

1069