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

How to maintain a fill factor in existing indexes?

699

Does partitioning ssd reduce performance?

637

How do you delete a trigger?

742

What is ms sql server triggers?

705

What is the sql server 2000 version number?

770

Explain what are sparse columns?

745

What is user defined stored procedures?

715

What is the difference between commit and rollback?

670

Explain the concept of view and Types of views in SQL server?

770

Explain database normalization?

871

What is the partitioning method?

743

Can you get second highest salary from the table?

722

What are the disadvantages of indexes?

697

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

743

What are commonly used odbc functions in php?

718