How to display Date as Month-Year

Question

Hi I want to display 30/11/2023 Date as Nov'23 Regards

Jignesh Kumar · Answer

Hello Ramco, You can use this one, DECLARE @inputDate VARCHAR(10) = '30/11/2023' SELECT LEFT(DATENAME( MONTH, CONVERT(DATE, @inputDate, 103)), 3) + ''' ' + CONVERT(VARCHAR(4), DATEPART(YEAR, CONVERT(DATE, @inputDate, 103))) AS formatted_date

Amit Mohanty · Answer

Try this DECLARE @yourDateString VARCHAR(10) = '30/11/2023'; DECLARE @yourDate DATE = CONVERT(DATE, @yourDateString, 103); SELECT CONCAT(FORMAT(@yourDate, 'MMM'), '''', FORMAT(@yourDate, 'yy')) AS FormattedDate;

Vishal Joshi · Answer

Hello Ramco, Please try the below SQL Query code to get date format as a month and year (MMM'yy). DECLARE @frDate DATETIME SET @frDate = GETDATE() select left(datename(month, @frDate), 3) + '''' + right(datename(year, @frDate), 2) Please make sure that input variable or column datatype should be DateTime. Thanks Vishal

Mohammad Hussain · Answer

Hi Ramco, Please try this, DECLARE @Date1 DATE = '2023-11-30'; SELECT FORMAT(@Date1, 'MMM''yy') AS NewDate;

Anandu G Nath · Answer

ASp.NetHub #Asp.NetHub Check this channel for more Videos https://youtube.com/@asp.netsimpletutorial3964?si=1SdUvvq2SuNiLVzA

Rafnas T P · Answer

Hi Ramco, You can wright below select query to format you date SELECT DATE_FORMAT('2023-11-30', '%b''%y') AS FormattedDate; if this answers your query, please accept this answer.

Jithu Thomas · Answer

CREATE PROCEDURE FormatDate @inputDate NVARCHAR(10) AS BEGIN DECLARE @formattedDate NVARCHAR(6) -- Convert the input date to a datetime object DECLARE @date datetime = CONVERT(datetime, @inputDate, 103) -- Format the date as 'MMM' for abbreviated month and 'YY' for the last two digits of the year SET @formattedDate = FORMAT(@date, 'MMM''YY') -- Return the formatted date SELECT @formattedDate AS FormattedDate END you can execute the code by the following code: - EXEC FormatDate '30/11/2023';

How to display Date as Month-Year

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (7)