How to convert date to dd-mm-yy format in SQL Server Query

band.atu...

SOLVED CLOSED ACTIVE ANSWERED
User: band.atul
Posted: on Jun 23, 2014 05:33 AM
Forum: SQL Server
Answer: 1
Views: 3243

IIn my database the date is 20140623 yyyymmdd format but when get this date from database using query then I want to change the date dd-mm-yy format how to convert at runtime fire query

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

Azim

0 1

Reply
ANSWER
User: Azim
Replied: on Jun 23, 2014 06:05 AM
Modified: on Jun 26, 2014 11:01 PM
Report

Refer this

DECLARE @Date DATETIME
SET @Date ='20140623'
SELECT CONVERT(VARCHAR(11),@Date,105)

Output

23-06-2014

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

How to convert date to dd-mm-yy format in SQL Server Query

Company

Explore

Follow us

Contact Us