how to display the months based on date

vinnu

15y2.6k

hi..
this is my SP

USE

[TASKDB]

SET

ANSI_NULLS ON QUOTED_IDENTIFIER ON

ALTER PROCEDURE [dbo].[GetCmtRpt]-- Add the parameters for the stored procedure here

@logid

BEGIN

int

SET NOCOUNT ON;

-- Insert statements for procedure here

SELECT Date ,From_Name ,To_Name ,Todays_Task ,Tommorrows_Task ,Status,Comments,Date as months from TaskSheet inner join

END

i want to display the months field as jan feb mar based on date how to do...?

3 Replies

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

Jaganathan Bantheswaran15y ago
Hi,

In my previous reply, Instead of GETDATE() you can give your date variable.
Jaganathan Bantheswaran15y ago
Hi,

SELECT CONVERT(VARCHAR(9), GETDATE(), 6) AS [DD MON YY] -- 23 feb 11

SELECT CONVERT(VARCHAR(11), GETDATE(), 106) AS [DD MON YYYY] -- 23 feb 2011

Try this. Its working fine.
Soft Corner15y ago
Hi,

    Try this in ur sproc

         select DATENAME(month, '5/1/06') --'mm/dd/yy'