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 a field name?

0 Answers  

What is the difference between SSAS 2000 and SSAS 2005?

1 Answers   APX,

What is the difference between substr and charindex in the sql server?

0 Answers  

In what version of sql server were synonyms released?

0 Answers  

In which tcp/ip port does sql server run? Can it be changed?

0 Answers  




How to change the ownership of a schema in ms sql server?

0 Answers  

Tell me what are the essential components of sql server service broker?

0 Answers  

what are the new features of sql server 2005?

8 Answers   HP, Keane India Ltd,

How can you list all the columns in a database?

0 Answers  

sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers  

What are the purpose of Normalisation?

0 Answers   HCL,

what's the difference between SQL & MY-SQl...? And what we learn from these ....?

2 Answers   Broadridge,

For more SQL Server Interview Questions Click Here
Categories