Sqlserver date, string format conversion

Select convert (char, your date field, 120) as date2 from table

MSSQL outputs data in the system time format by default. You can adjust the system time format to solve this problem.

Of course, it is more flexible to solve in the program, convert (char, date, n) output of the various styles
N date style
0 04 2 2005 AM
1 04/02/05
2 05.04.02
3 02/04/05
4 02.04.05
5 02-04-05
6 02 04 05
7 04 02, 05
09:06:18
9 04 2 2005 9: 06: 18: 857am
10 04-02-05
11 05/04/02
12 050402
13 02 04 2005 09: 06: 18: 857
14 09: 06: 18: 857
20 09:06:18
21 09:06:18. 857
22 04/02/05 9:06:18 AM
23
24 09:06:18
25 09:06:18. 857
100 04 2 2005 AM
101
102 2005.04.02
103 02/04/2005
104 02.04.2005
105 02-04-2005
106 02 04 2005
107 04 02,200 5
09:06:18 108
109 04 2 2005 9: 06: 18: 857am
110 04-02-2005
111 2005/04/02
112 20050402
113 02 04 2005 09: 06: 18: 857
114 09: 06: 18: 857
120 09:06:18
121 09:06:18. 857
126: 06: 18.857