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 is the security model used in sql server 2005?

0 Answers  

Is INSTEAD OF trigger directly applicable to Table ?

0 Answers  

What are SQL Jobs, please mention the use of it and how to create them.

1 Answers   247Customer,

how to find the second salary?

10 Answers   HCL, Prithvi,

How can we rewrite sub-queries into simple select statements or with joins?

0 Answers  

What is the purpose of update statistics and scope_identity() function?

0 Answers  

Which joins are sql server default?

0 Answers  

Explain what is the main purpose of having conversation group?

0 Answers  

How to create an index on an existing table in ms sql server?

0 Answers  

What is an index. What are the types?

0 Answers  

how do we find every fifth record in a table

14 Answers   Aspire, HCL,

What is the SQL?????????????????????????????

5 Answers   CMS,

For more SQL Server Interview Questions Click Here
Categories