Data Type MSSQL

  1. Home
  2. MSSQL
  3. Data Type
  4. 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)