How to find Last Day of Any Month?

Read Time:16 Second

Last Day of Previous MonthSELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0))

Last Day of Current MonthSELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0))

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

Post Views: 266

0 Comments

Oldest

Newest Most Voted

Inline Feedbacks

View all comments

22 September 202326 September 2024

Microsoft and Oracle expand partnership to deliver Oracle Database Services

Microsoft joins Oracle as the only other hyperscaler to offer Oracle Cloud Infrastructure Database Services to simplify cloud migration, multicloud deployment and management Microsoft and...
15 February 202320 September 2024

High level vs low level design ?

1. High-Level Design (HLD) Overview: HLD is the macro-level design phase that provides a broad view of the system. It outlines the architecture and major...
7 February 202320 September 2024

What happens when you type a URL into your browser?

URL stands for Uniform Resource Locator. A URL is the address of a website that you can find in the address bar of your web...
23 August 202320 September 2024

What is latency and throughput in performance testing?

Latency and throughput are two important metrics used to assess the performance of software applications or systems. They provide insights into how well an application...
23 August 202329 August 2023

What is your role in the ongoing project as an Engineering Manager?

In the ongoing project, my role as the Engineering Manager involves overseeing and coordinating various aspects of the project's technical development. I work closely with...

7 May 2025

Yarn vs npm: A Beginner’s Guide to JavaScript Package Managers

📦 Yarn vs npm: A Beginner’s Guide to JavaScript Package Managers 🧠 What is a Package Manager? A package manager automates the process of: Installing...
7 May 2025

Understanding Frontend Development from Inception to Innovation

🎯 Purpose: This article serves as a beginner-friendly, full-spectrum guide to frontend development, covering: Core technologies (HTML, CSS, JS, React, Vue, etc.) Their evolution and...
2 May 20252 May 2025

Understanding Startup.cs, appsettings.json, Filters, and using Keyword in .NET Core – With Real-World Examples

📌 1. Startup.cs in ASP.NET Core ✅ Definition Startup.cs is the central configuration file for your ASP.NET Core application, used to register services and define...
20 April 202520 April 2025

Technical Architect vs. Solutions Architect: Understanding the Differences, Career Paths, and Real-Time Examples

In the ever-evolving tech world, two roles often get mentioned interchangeably but serve very different purposes—Technical Architect and Solutions Architect. Whether you're planning your next...
11 April 2025

30 Algorithm Challenges in C# (With Real-World Examples & Code)

✨ Part 1: Linked Lists & Arrays (Problems 1–5) ✅ 1. Reverse a Linked List �� Problem Statement: You are given the head of a...

Would love your thoughts, please comment.x

()

Most Viewed Posts