Programming/MSSQL
[MSSQL] 날짜 양식
홍상길
2012. 1. 20. 15:31
select CONVERT(VARCHAR(50), GETDATE(), 1)
| 0 | Sep 27 2011 8:53AM |
| 1 | 09/27/11 |
| 2 | 11.09.27 |
| 3 | 2027-09-11 |
| 4 | 01.01.12 |
| 5 | 2001-01-12 |
| 6 | 01-Jan-12 |
| 7 | 01-Jan-12 |
| 8 | 1:01:01 |
| 9 | Jan 01 2012 1:01:01:001AM |
| 10 | 2001-01-12 |
| 11 | 2012-01-01 |
| 12 | 120101 |
| 13 | 01 Jan 2012 01:01:01:001 |
| 14 | 01:01:01:001 |
| 20 | 2012-01-01 1:01 |
| 21 | 01:01.0 |
| 22 | 2001-01-12 1:01 |
| 23 | 2012-01-01 |
| 24 | 1:01:01 |
| 25 | 01:01.0 |
| 100 | Jan 1 2012 1:01AM |
| 101 | 01/01/2012 |
| 102 | 2012.01.01 |
| 103 | 01/01/2012 |
| 104 | 01.01.2012 |
| 105 | 01-01-2012 |
| 106 | 01-Jan-12 |
| 107 | 01-Jan-12 |
| 108 | 1:01:01 |
| 109 | Jan 01 2012 1:01:01:001AM |
| 110 | 01-01-2012 |
| 111 | 2012-01-01 |
| 112 | 20120101 |
| 113 | 01 Jan 2012 01:01:01:001 |
| 114 | 01:01:01:001 |
| 120 | 2012-01-01 1:01 |
| 121 | 01:01.0 |
| 126 | 2012-01-01T01:01:01.001 |
| 127 | 2012-01-01T01:01:01.001 |
| 130 | 01 ???? 1432 1:01:01:001AM |
| 131 | 01/01/1432 1:01:01:001AM |