Find Last Day of Any Month (SQL Server)

a) Find the last day of the previous month, current month and next month.

  • Last Day of Previous Month
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0))
  • Last Day of Current Month
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0))

  • Last Day of Next Month
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+2,0))

 b). Last day of any day specified.

  • Last Day of Any Month and Year
DECLARE @dtDate DATETIMESET @dtDate = '8/18/2007'SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,@dtDate)+1,0))

Comments

Post a Comment

Please leave your comments

Popular posts from this blog

DBA /BI Engineer Post

Country: Tanzania City: Dar Es Salaam Qualification A Bachelor’s degree in Computer Engineering, Computer Science, Industrial Engineering/Operations  Mathematics, Management Information Systems. Skills in Database operations, SQL queries, etc Knowledge of best practices and principles for ETL, data modeling, dashboards, report design, analytics, and data mining Strong work ethic Ability to multi-task effectively and be comfortable working in a fast-paced, dynamic environment without close guidance or supervision Strong leadership skills Excellent verbal and written communication skills High degree of attention to detAILS dEADLINE 16/07/2013
Read more
Image
Elements for IS Auditing An information system is not just a computer. Today's information systems are complex and have many components that piece together to make a business solution. Assurances about an information system can be obtained only if all the components are evaluated and secured. The proverbial weakest link is the total strength of the chain. The major elements of IS audit can be broadly classified: Physical and environmental review —This includes physical security, power supply, air conditioning, humidity control and other environmental factors. System administration review —This includes security review of the operating systems, database management systems, all system administration procedures and compliance. Application software review —The business application could be payroll, invoicing, a web-based customer order processing system or an enterprise resource planning system that actually runs the business. Review of such application software includes acce...
Read more

How to Fix ( Failed To Create A Phonebook Entry)

Failed To Create A Phonebook Entry |Fix This Error If you are logged on to your PC or laptop using a Guest account. Try to logon using an account with Administrative rights and then try if you are getting the same error ”Failed to create a phonebook entry". If the answer is yes, then try the following… For Windows XP Operating System: First ensure show hidden Files & Folders is checked under folder options. From  My Computer  select  Tools  followed by  Folder Options  then  View.  Under  Advanced settings  tick  Show Hidden Files and Folders  then select  Apply , then  OK. Browse to  C:\Documents and Settings\All Users\Application Data\Microsoft\Network\Connections\Pbk Right click on  Rasphone  file and click  Properties . If the  Read Only  box is checked, remove this, then select  Apply  then  OK . Rename the folder called  pbk  to...
Read more