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

Can two tables share a primary key?

1011

what is checksum in sql server.........???

1677

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1194

What is a subquery in a select query statement in ms sql server?

1124

What is an index. What are the types?

1078

Which language rdl files made of?

130

How to create a simple user defined function in ms sql server?

1008

What is difference between line feed ( ) and carriage return ( )?

896

Do you know what is openxml in sql server?

1063

How to call stored procedure using http soap?

1067

What are data files?

1033

what is blocking? : Sql server database administration

1029

What is the filtered index?

1046

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

877

What is an identity?

1003