Convert datetime to String using the CONVERT function in SQL Server

CONVERT (varchar (ten), date, 23)

1 02/22/06 CONVERT (varchar (), date, 1)

0	Feb 2006 4:26pm	CONVERT (CHAR), Current_timestamp, 0)
1	02/22/06	CONVERT (CHAR (8), Current_timestamp, 1)
2	06.02.22	CONVERT (CHAR (8), Current_timestamp, 2)
3	22/02/06	CONVERT (CHAR (8), Current_timestamp, 3)
4	22.02.06	CONVERT (CHAR (8), Current_timestamp, 4)
5	22-02-06	CONVERT (CHAR (8), Current_timestamp, 5)
6	06	CONVERT (CHAR (9), Current_timestamp, 6)
7	Feb 22, 06	CONVERT (CHAR (Ten), Current_timestamp, 7)
8	16:26:08	CONVERT (CHAR (8), Current_timestamp, 8)
9	Feb 2006 4:26:08:020pm	CONVERT (CHAR (+), Current_timestamp, 9)
10	02-22-06	CONVERT (CHAR (8), Current_timestamp, 10)
11	06/02/22	CONVERT (CHAR (8), Current_timestamp, 11)
12	060222	CONVERT (CHAR (6), Current_timestamp, 12)
13	2006 16:26:08:020	CONVERT (CHAR), Current_timestamp, 13)
14	16:26:08:037	CONVERT (CHAR (), Current_timestamp, 14)
20	2006-02-22 16:26:08	CONVERT (CHAR), Current_timestamp, 20)
21st	2006-02-22 16:26:08.037	CONVERT (CHAR (at), Current_timestamp, 21)
22	02/22/06 4:26:08 PM	CONVERT (CHAR (), Current_timestamp, 22)
23	2006-02-22	CONVERT (CHAR (Ten), Current_timestamp, 23)
24	16:26:08	CONVERT (CHAR (8), Current_timestamp, 24)
25	2006-02-22 16:26:08.037	CONVERT (CHAR (at), Current_timestamp, 25)
100	Feb 2006 4:26pm	CONVERT (CHAR), Current_timestamp, 100)
101	02/22/2006	CONVERT (CHAR (Ten), Current_timestamp, 101)
102	2006.02.22	CONVERT (CHAR (Ten), Current_timestamp, 102)
103	22/02/2006	CONVERT (CHAR (Ten), Current_timestamp, 103)
104	22.02.2006	CONVERT (CHAR (Ten), Current_timestamp, 104)
105	22-02-2006	CONVERT (CHAR (Ten), Current_timestamp, 105)
106	2006	CONVERT (CHAR (one), Current_timestamp, 106)
107	Feb 22, 2006	CONVERT (CHAR (), Current_timestamp, 107)
108	16:26:08	CONVERT (CHAR (8), Current_timestamp, 108)
109	Feb 2006 4:26:08:067pm	CONVERT (CHAR (+), Current_timestamp, 109)
the	02-22-2006	CONVERT (CHAR), Current_timestamp,
111	2006/02/22	CONVERT (CHAR (Ten), Current_timestamp, 111)
112	20060222	CONVERT (CHAR (8), Current_timestamp, 112)
113	2006 16:26:08:067	CONVERT (CHAR), Current_timestamp, 113)
114	16:26:08:067	CONVERT (CHAR (), Current_timestamp, 114)
120	2006-02-22 16:26:08	CONVERT (CHAR), Current_timestamp, 120)
121	2006-02-22 16:26:08.080	CONVERT (CHAR (at), Current_timestamp, 121)
126	2006-02-22t16:26:08.080	CONVERT (CHAR (at), Current_timestamp, 126)
127	2006-02-22t16:26:08.080	CONVERT (CHAR (at), Current_timestamp, 127)
130	???? 1427 4:26:08:080pm	CONVERT (CHAR (+), Current_timestamp, 130)
131	24/01/1427 4:26:08:080pm	CONVERT (CHAR), Current_timestamp, 131

Convert datetime to String using the CONVERT function in SQL Server