حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

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: 3953

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

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

Contact Us

Email: webmaster@aspsnippets.com
Address:
ASPSNIPPETS PRIVATE LIMITED
G-110, SHAGUN ARCADE,
MALAD (EAST),
MUMBAI, MAHARASHTRA,
INDIA 400097.

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

Company

Explore

Follow us

Contact Us