Convert from MM/dd/yyyy to yyyy-MM-dd

SELECT        
	 FORMAT(CAST(Description AS date), 'yyyy-MM-dd') 
FROM            
	dbo.tblTable
WHERE        
	(Description LIKE '%/20%')
Last modified: August 2, 2019

Author

Comments

Write a Reply or Comment