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

yy date format in SQL Server

asrul

Hi All,

How to change date format on select statement.

My Select statement:

Select Date_Joined from Emp_Info

Result:

14/02/15 12:00:00 AM

I want my output like this:

14/02/15

Shashika...

0 1

Hi,

Please refer below sql

SQL

DECLARE @Date DATETIME 
SET @Date=  GETDATE()
SELECT CONVERT(VARCHAR,@Date,103)

Output

21/09/2017

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

13.59.14.52