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 apply operator in sql?

957

Why are you getting errors when creating a new odbc dsn?

1166

What is key set driven?

893

Explain primary key in sql server?

970

What are different types of database indexes?

1011

What is join query?

837

What is function of ROLLUP ?

1036

Why should one not prefix user stored procedures with ‘sp_’?

985

Does an index slow down updates on indexed columns?

912

How you can get the list of largest tables in a database?

943

What do you understand by the analysis services in sql server?

890

when would you go for denormalization? : Sql server database administration

810

Why it is recommended to avoid referencing a floating point column in the where clause?

919

Why de-normalization required?

940

What are data files?

982