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

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

Question Posted / vijay

Answer Posted / vijay

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

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Where are stored procedures in sql server?

1006

What is the difference between ddl,dml and dcl commands?

1056

How to disable stored procedure sql server?

1525

What is a sql join?

951

How to execute a stored procedure in ms sql server?

1068

What is an identity?

937

Explain how to send email from sql database?

972

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

954

What is the default schema of your login session in ms sql server?

993

How adventureworkslt tables are related?

879

How to convert a numeric expression from one data type to another?

932

What is a recursive stored procedure in sql server?

1085

how can u get last observation in an unknown dataset ?

2387

What do you understand by a view?

933

How to integrate the ssrs reports in application?

933