Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / saravakumar

Answers were Sorted based on User's Feedback



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

Answer / saravakumar

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

Is This Answer Correct ?    31 Yes 2 No

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

Answer / vijay

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

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More SQL Server Interview Questions

what operator performs pattern matching?

2 Answers  

What is a unique index?

0 Answers  

How can you set the threshold at which sql server will generate keysets asynchronously?

0 Answers  

Detail about the hardware which is supported by SQL server?

0 Answers  

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,




What will be the maximum number of indexes per table?

0 Answers  

Difference between drill down and drill through report.

0 Answers  

What is an indice?

0 Answers  

What is the difference between resultset and resultsetmetadata?

0 Answers  

Repair mdf file

2 Answers  

Tell me what is the order in which the sql query is executed?

0 Answers  

How to write character string constants or literals in ms sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories