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

Question Posted / saravakumar

2 Answers
12883 Views
I also Faced
E-Mail Answers

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 does sql server mean?

0 Answers

What is a trigger? Why we need it?

0 Answers Accenture,

How the data stores in a page?

1 Answers

What is the difference between ‘having’ clause and a ‘where’ clause?

0 Answers

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

0 Answers

Can we move Resource database from one path to another? If yes,How can we?

1 Answers Wipro,

Where are magic tables stored ? Is it in the same database where it is created ?

4 Answers

What is the Difference beween sql server 2005 and sql server 2008

3 Answers CMC, Hitech,

What is collation sensitivity? Explain different types.

0 Answers

Is Sql non procedural query language?

1 Answers Verifone,

What do you understand by sql server agent?

0 Answers

What is lookup override?

0 Answers Informatica,

For more SQL Server Interview Questions Click Here