How to display Date as Month-Year

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

Hi Ramco,

Please try this,

DECLARE @Date1 DATE = '2023-11-30';

SELECT FORMAT(@Date1, 'MMM''yy') AS NewDate;

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;

ASp.NetHub

 #Asp.NetHub

 Check this channel for more Videos

 https://youtube.com/@asp.netsimpletutorial3964?si=1SdUvvq2SuNiLVzA  

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

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.