Convert DateTime to dd-MMM-yyyy hh:mm format in SQL Server

nagaraju...

SOLVED CLOSED ACTIVE ANSWERED
User: nagaraju60
Posted: on Nov 19, 2017 10:22 PM
Forum: SQL Server
Answer: 1
Views: 11118

Hi all, by using below sql statement i want to get required format

declare @tdy datetime
SET @tdy=GETDATE()

SELECT @tdy

result : 2017-11-18 11:50:27.067

by using above result i want to get below format

18-Nov-2017 11:50

how to achieve this query..

Thanks in advance

Download FREE API for Word, Excel and PDF in ASP.Net

kalpesh

0 1

Reply
ANSWER
User: kalpesh
Replied: on Nov 19, 2017 10:37 PM
Modified: on Nov 19, 2017 10:37 PM
Report

Hi nagaraju60,

Try below test query for your reference.

SQL

DECLARE @FormatedDate VARCHAR(20)
SET @FormatedDate  = STUFF(STUFF(CONVERT(CHAR(20), getdate(), 113),3,1, '-'),7,1,'-')
SELECT SUBSTRING(@FormatedDate,0,LEN(@FormatedDate)-2)

Result

20-Nov-2017 09:53

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Convert DateTime to dd-MMM-yyyy hh:mm format in SQL Server

Company

Explore

Follow us

Contact Us