mssql date format

select convert(varchar(30), (select dateadd(month,-3,getdate() ) ), 112 ) as Before_3Month;

select convert(varchar(8), (select dateadd(month,0,convert(datetime,'') ) ), 112 ) as Before_3Month;

SELECT CONVERT(VARCHAR, GETDATE(), 0)  /* Aug 27 2014  8:45AM */

SELECT CONVERT(VARCHAR, GETDATE(), 1)  /* 08/27/14 */

SELECT CONVERT(VARCHAR, GETDATE(), 2)  /* 14.08.27 */

SELECT CONVERT(VARCHAR, GETDATE(), 3)  /* 27/08/14 */

SELECT CONVERT(VARCHAR, GETDATE(), 4)  /* 27.08.14 */

SELECT CONVERT(VARCHAR, GETDATE(), 5)  /* 27-08-14 */

SELECT CONVERT(VARCHAR, GETDATE(), 6)  /* 27 Aug 14 */

SELECT CONVERT(VARCHAR, GETDATE(), 7)  /* Aug 27, 14 */

SELECT CONVERT(VARCHAR, GETDATE(), 8)  /* 08:49:39 */ 시분초만 나옴

SELECT CONVERT(VARCHAR, GETDATE(), 9)  /* Aug 27 2014  8:50:02:333AM */

SELECT CONVERT(VARCHAR, GETDATE(), 10)   /* 08-27-14 */

SELECT CONVERT(VARCHAR, GETDATE(), 11)   /* 14/08/27 */

SELECT CONVERT(VARCHAR, GETDATE(), 12)   /* 140827  */

SELECT CONVERT(VARCHAR, GETDATE(), 13)   /* 27 Aug 2014 08:51:52:410 */

SELECT CONVERT(VARCHAR, GETDATE(), 14)   /* 08:52:10:567 */ 시분초:1/100초

SELECT CONVERT(VARCHAR, GETDATE(), 20)   /* 2014-08-27 08:52:23 */

SELECT CONVERT(VARCHAR, GETDATE(), 21)   /* 2014-08-27 17:52:43.893 */

SELECT CONVERT(VARCHAR, GETDATE(), 22)   /* 08/27/14  8:53:23 AM */

SELECT CONVERT(VARCHAR, GETDATE(), 23)   /* 2014-08-27 */

SELECT CONVERT(VARCHAR, GETDATE(), 24)   /* 08:53:49 */ 시분초만 나옴

SELECT CONVERT(VARCHAR, GETDATE(), 25)   /* 2014-08-27 08:55:21.567 */

SELECT CONVERT(VARCHAR, GETDATE(), 100)  /* Aug 27 2014  8:55AM */

SELECT CONVERT(VARCHAR, GETDATE(), 101)  /* 08/27/2014 */

SELECT CONVERT(VARCHAR, GETDATE(), 102)  /* 2014.08.27 */

SELECT CONVERT(VARCHAR, GETDATE(), 104)  /* 27.08.2014 */

SELECT CONVERT(VARCHAR, GETDATE(), 105)  /* 27-08-2014 */

SELECT CONVERT(VARCHAR, GETDATE(), 106)  /* 27 Aug 2014 */

SELECT CONVERT(VARCHAR, GETDATE(), 107)  /* Aug 27, 2014 */

SELECT CONVERT(VARCHAR, GETDATE(), 108)  /* 08:57:23 */ 시분초만 나옴

SELECT CONVERT(VARCHAR, GETDATE(), 109)  /* Aug 27 2014  8:58:10:273AM */

SELECT CONVERT(VARCHAR, GETDATE(), 110)  /* 08-27-2014 */

SELECT CONVERT(VARCHAR, GETDATE(), 111)  /* 2014/08/27 */

SELECT CONVERT(VARCHAR, GETDATE(), 112)  /* 20140827 */

SELECT CONVERT(VARCHAR, GETDATE(), 113)  /* 27 Aug 2014 08:58:40:650 */

SELECT CONVERT(VARCHAR, GETDATE(), 114)  /* 08:59:02:630 */

SELECT CONVERT(VARCHAR, GETDATE(), 120)  /* 2014-08-27 08:59:23 */

SELECT CONVERT(VARCHAR, GETDATE(), 121)  /* 2014-08-27 08:59:23.280 */

SELECT CONVERT(VARCHAR, GETDATE(), 126)  /* 2014-08-27T08:59:23.280 */

SELECT CONVERT(VARCHAR, GETDATE(), 127)  /* 2014-08-27T08:59:23.280 */

SELECT CONVERT(VARCHAR, GETDATE(), 130)  /* 2 ?? ?????? 1435  8:59:23:280 */

SELECT CONVERT(VARCHAR, GETDATE(), 131)  /* 2/11/1435  8:59:23:280AM */

THE WATCHING