Mega Code Archive

 

Categories / MSSQL / Data Type

 

Combine CONVERT() and DATEADD() to format

3> 4> SELECT CONVERT(VarChar(20), DATEADD(m, -9, '9-8-1989'), 101) 5> GO -------------------- 12/08/1988 (1 rows affected)