Home

Current Article

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

By admin on Mar 14, 2007 in Ms Sql Server Interview Questions

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

2 Comment(s)
By santosh on Dec 3, 2007 | Reply

SELECT add_months((last_day(’&DATE’)),-1)+1 FROM dual
By santosh on Dec 3, 2007 | Reply

SELECT to_char(add_months((last_day(’&DATE’)),-1)+1,’Day’) FROM dual

Tech Portals
Recent Comments
- Ojaswi on SAP-HR Interview Questions
- Balamurugan G on What is difference between TRUNCATE & DELETE
- sudha on What type of headers have to add in the mail function in which file a attached?
- lizzeelike on How many ways can we get the value of current session id?
- Niti on Can I have multiple main methods in the same class?
Tags
Basis Interview Questions Classic Job Interview Questions COBOL Interview Questions Database interview questions DBA Interview Questions FI Interview Questions HR Interview Questions interview questions for DBA Interview Questions on DBA Interview Questions on SAP Interview Questions On SAP ABAP Interview Questions on SQL MySQL interview questions Networking Informational Interview Questions Oracle Basics Interview Questions Oracle Interview Questions Oracle on Linux/Unix questions PP Interview Questions R/3 Interview Questions Sample Networking Informational Interview Questions SAP-Basis Interview Questions SAP-FI Interview Questions SAP-HR Interview Questions SAP-PP Interview Questions SAP-R/3 Interview Questions SAP-SD Interview Questions SAP Interview Questions SQL Interview Questions Tough Oracle Interview Questions Typical Interview Questions