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
- vignesh on 50 Aptitude questions
- shaan on Tough Oracle Interview Questions
- mounicareddy on What is the difference between microprocessor and microcontroller?
- J.shylender on Hyderabad Companies & Consultants
- prabhu.r on File format for SQR?
Tags
Basis 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 Oracle Basics Interview Questions Oracle Interview Questions Oracle on Linux/Unix questions PP Interview Questions R/3 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