johnwalker10 (12/23/2015)
try the below query to get result in DD/MM/YY format.
select LEFT(convert(varchar(10), @date, 103),6) + Right(Year(@date)+ 1,2)
Gosh, no... Never do date/time formatting for a GUI from SQL Server. Let the GUI do the formatting so that local datetime settings can prevail. As previously suggested on this thread, a PHP forum would be the best place to discover how to do this.
--Jeff Moden
Change is inevitable... Change for the better is not.