Write a SQL Query to find first Week Day of month?
Answers were Sorted based on User's Feedback
Answer / saravakumar
SELECT DATENAME(dw, DATEADD(dd, - DATEPART(dd, GETDATE()) +
1, GETDATE())) AS FirstDay
| Is This Answer Correct ? | 31 Yes | 2 No |
Answer / vijay
SELECT DATENAME(dw, DATEADD(dd, – DATEPART(dd, GETDATE()) + 1, GETDATE())) AS FirstDay
| Is This Answer Correct ? | 1 Yes | 1 No |
How do you rename a table in sql server?
What is the exact numeric data type in sql?
How do I create a trace in sql server?
What are the tables in sql?
Is index a datbase objects in sql server?
What are the different editions available in sql server 2000?
which database is best to use in oracle and sql server? explain reasons?
Why we need sql server?
How to count rows with the count(*) function in ms sql server?
What is Replication?
What does null mean?
What is an Index?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)