string formattedDate = System.DateTime.Now.ToString(@"dd\/MM\/yy");
DateTime.Now
SELECT CONVERT(nvarchar(10), getdate(), 103) --// 13/09/2015 --or SELECT CONVERT(nvarchar(10), getdate(), 3) --// 13/09/15 --or SELECT CONVERT(nvarchar(10), dateColumn, 3) from TableName
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)