@@ -72,50 +72,50 @@ |
||
72 | 72 | if ($s) $s .= '+'; |
73 | 73 | $ch = $fmt[$i]; |
74 | 74 | switch ($ch) { |
75 | - case 'Y': |
|
76 | - case 'y': |
|
77 | - $s .= "datename(yyyy,$col)"; |
|
78 | - break; |
|
79 | - case 'M': |
|
80 | - $s .= "convert(char(3),$col,0)"; |
|
81 | - break; |
|
82 | - case 'm': |
|
83 | - $s .= "replace(str(month($col),2),' ','0')"; |
|
84 | - break; |
|
85 | - case 'Q': |
|
86 | - case 'q': |
|
87 | - $s .= "datename(quarter,$col)"; |
|
88 | - break; |
|
89 | - case 'D': |
|
90 | - case 'd': |
|
91 | - $s .= "replace(str(day($col),2),' ','0')"; |
|
92 | - break; |
|
93 | - case 'h': |
|
94 | - $s .= "substring(convert(char(14),$col,0),13,2)"; |
|
95 | - break; |
|
96 | - |
|
97 | - case 'H': |
|
98 | - $s .= "replace(str(datepart(hh,$col),2),' ','0')"; |
|
99 | - break; |
|
100 | - |
|
101 | - case 'i': |
|
102 | - $s .= "replace(str(datepart(mi,$col),2),' ','0')"; |
|
103 | - break; |
|
104 | - case 's': |
|
105 | - $s .= "replace(str(datepart(ss,$col),2),' ','0')"; |
|
106 | - break; |
|
107 | - case 'a': |
|
108 | - case 'A': |
|
109 | - $s .= "substring(convert(char(19),$col,0),18,2)"; |
|
110 | - break; |
|
111 | - |
|
112 | - default: |
|
113 | - if ($ch == '\\') { |
|
114 | - $i++; |
|
115 | - $ch = substr($fmt, $i, 1); |
|
116 | - } |
|
117 | - $s .= $ch; |
|
118 | - break; |
|
75 | + case 'Y': |
|
76 | + case 'y': |
|
77 | + $s .= "datename(yyyy,$col)"; |
|
78 | + break; |
|
79 | + case 'M': |
|
80 | + $s .= "convert(char(3),$col,0)"; |
|
81 | + break; |
|
82 | + case 'm': |
|
83 | + $s .= "replace(str(month($col),2),' ','0')"; |
|
84 | + break; |
|
85 | + case 'Q': |
|
86 | + case 'q': |
|
87 | + $s .= "datename(quarter,$col)"; |
|
88 | + break; |
|
89 | + case 'D': |
|
90 | + case 'd': |
|
91 | + $s .= "replace(str(day($col),2),' ','0')"; |
|
92 | + break; |
|
93 | + case 'h': |
|
94 | + $s .= "substring(convert(char(14),$col,0),13,2)"; |
|
95 | + break; |
|
96 | + |
|
97 | + case 'H': |
|
98 | + $s .= "replace(str(datepart(hh,$col),2),' ','0')"; |
|
99 | + break; |
|
100 | + |
|
101 | + case 'i': |
|
102 | + $s .= "replace(str(datepart(mi,$col),2),' ','0')"; |
|
103 | + break; |
|
104 | + case 's': |
|
105 | + $s .= "replace(str(datepart(ss,$col),2),' ','0')"; |
|
106 | + break; |
|
107 | + case 'a': |
|
108 | + case 'A': |
|
109 | + $s .= "substring(convert(char(19),$col,0),18,2)"; |
|
110 | + break; |
|
111 | + |
|
112 | + default: |
|
113 | + if ($ch == '\\') { |
|
114 | + $i++; |
|
115 | + $ch = substr($fmt, $i, 1); |
|
116 | + } |
|
117 | + $s .= $ch; |
|
118 | + break; |
|
119 | 119 | } |
120 | 120 | } |
121 | 121 | return $s; |