lib/Doctrine/DBAL/Platforms/DB2Platform.php 1 location
|
@@ 195-205 (lines=11) @@
|
| 192 |
|
*/ |
| 193 |
|
protected function getDateArithmeticIntervalExpression($date, $operator, $interval, $unit) |
| 194 |
|
{ |
| 195 |
|
switch ($unit) { |
| 196 |
|
case self::DATE_INTERVAL_UNIT_WEEK: |
| 197 |
|
$interval *= 7; |
| 198 |
|
$unit = self::DATE_INTERVAL_UNIT_DAY; |
| 199 |
|
break; |
| 200 |
|
|
| 201 |
|
case self::DATE_INTERVAL_UNIT_QUARTER: |
| 202 |
|
$interval *= 3; |
| 203 |
|
$unit = self::DATE_INTERVAL_UNIT_MONTH; |
| 204 |
|
break; |
| 205 |
|
} |
| 206 |
|
|
| 207 |
|
return $date . ' ' . $operator . ' ' . $interval . ' ' . $unit; |
| 208 |
|
} |
lib/Doctrine/DBAL/Platforms/SqlitePlatform.php 1 location
|
@@ 140-150 (lines=11) @@
|
| 137 |
|
return "DATETIME(" . $date . ",'" . $operator . $interval . " " . $unit . "')"; |
| 138 |
|
|
| 139 |
|
default: |
| 140 |
|
switch ($unit) { |
| 141 |
|
case self::DATE_INTERVAL_UNIT_WEEK: |
| 142 |
|
$interval *= 7; |
| 143 |
|
$unit = self::DATE_INTERVAL_UNIT_DAY; |
| 144 |
|
break; |
| 145 |
|
|
| 146 |
|
case self::DATE_INTERVAL_UNIT_QUARTER: |
| 147 |
|
$interval *= 3; |
| 148 |
|
$unit = self::DATE_INTERVAL_UNIT_MONTH; |
| 149 |
|
break; |
| 150 |
|
} |
| 151 |
|
|
| 152 |
|
return "DATE(" . $date . ",'" . $operator . $interval . " " . $unit . "')"; |
| 153 |
|
} |