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';