byjg /
anydataset
@@ -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; |
