Sir,
I have an OUTPUT variable of datetime in stored procedure.
@MaturityDate datetime.
The result displaying via this variable is as 4/30/2044 12:00:00 AM.
But I want to display this date as 30 Apr 2044 excluding time.
How should i achieve this?
Hi Sumeet,
Check this example. Now please take its reference and correct your Query.
SQL
SELECT CONVERT(char(19) , Column_Name, 106)FROM TableName
Screenshot
© COPYRIGHT 2025 ASPSnippets.com ALL RIGHTS RESERVED.