Our Training Programs

All contents are copyright of their authors.

how to display previous month Character without including year & date

how to display previous month Character without including year & date

sankeerth m

4yAsked Jul 18, 2022, 9:05 AM1.1kSQL

Hi Friends,

how to display previous month Character without including year and date

Present date : 18-7-2022

output: June only previous month in characters should be displayed without any year and date

but i need only June from the output which should include year and date

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Satya Karki4y ago
In SQL
SELECT DATENAME(MM,CAST('2022-07-18' AS datetime)-1) as PreviousMonth
Satya Karki4y ago
Hi, in C# you get like below.
string previousMonth = DateTime.Now.AddMonths(-1).ToString("MMMM");
Amit Mohanty4y ago
Three different way to get month name.
DECLARE @date datetime2 = DATEADD(MONTH, -1, '2022-07-18')
SELECT FORMAT(@date, 'MMMM') AS Result;
SELECT DATENAME(MONTH, @date) AS Result;
SELECT {fn MONTHNAME(@date)} AS Result;
Vishal Yelve4y ago
1. SELECT (DATENAME(month,DATEADD(mm, -1, GETDATE()))) AS 'Previous Month'