-3

I want to convert a sql-server dateTime variable to MDY format.
Here is what it looks like :

2016-12-30 21:34:56.840

I would like it to look like : 12/30/2016

Ti Fi Shu
  • 67
  • 1
  • 8
  • Try this: SELECT CONVERT(varchar(10), cast('2016-12-30 21:34:56.840' as date), 101) --output: 12/30/2016 – rescobar Jan 21 '17 at 17:38

1 Answers1

0

You can convert using the 106 style from SQL Server

SELECT replace(convert(NVARCHAR, getdate(), 106), ' ', '/')
Henrique Giuliani
  • 296
  • 4
  • 15