Skip to main content

Return to Answer

TSQL FORMAT
Source Link
edit approved Mar 30, 2016 at 0:21
chancrovsky
edit approved Mar 30, 2016 at 0:21
chancrovsky
  • 580
  • 3
  • 11
declareDECLARE @yourdate datetimeDATETIME = '11/1/2014 12:25pm'    
selectSELECT convertCONVERT(dateDATE, @yourdate)

declare @yourdate datetime = '11/1/2014 12:25pm'    
select convert(date, @yourdate)

DECLARE @yourdate DATETIME = '11/1/2014 12:25pm'    
SELECT CONVERT(DATE, @yourdate)
Source Link
etni
etni
  • 81
  • 1
  • 2

declare @yourdate datetime = '11/1/2014 12:25pm'    
select convert(date, @yourdate)