src/SQL.php
private function stmt_fragment_datetime($delta) {
		$sign = $delta >= 0 ? '+' : '-';
		$delta = abs($delta);
		$date = '';
		switch ($this->dbtype) {
			case 'sqlite3':
				$date = "(datetime('now', '%s%s second'))";
				break;
			case 'pgsql':
				$date = (
					"(" .
						"now() at time zone 'utc' %s " .
						"interval '%s second'" .
					")::timestamp(0)"
				);
				break;
			case 'mysql':
				# mysql cannot accept function default; do
				# not use this on DDL
				$date = (
					"(date_add(utc_timestamp(), interval %s%s second))"
				);
				break;
		}
		return sprintf($date, $sign, $delta);
	}
private function stmt_fragment_datetime($delta) {
		$sign = $delta >= 0 ? '+' : '-';
		$delta = abs($delta);
		$date = '';
		switch ($this->dbtype) {
			case 'sqlite3':
				$date = "(datetime('now', '%s%s second'))";
				break;
			case 'pgsql':
				$date = (
					"(" .
						"now() at time zone 'utc' %s " .
						"interval '%s second'" .
					")::timestamp(0)"
				);
				break;
			case 'mysql':
				# mysql cannot accept function default; do
				# not use this on DDL
				$date = (
					"(date_add(utc_timestamp(), interval %s%s second))"
				);
				break;
		}
		return sprintf($date, $sign, $delta);
	}
private function stmt_fragment_datetime ( $ delta ) { $ sign = $ delta >= 0 ? '+' : '-' ; $ delta = abs ( $ delta ) ; $ date = '' ; switch ( $ this -> dbtype ) { case 'sqlite3' : $ date = "(datetime('now', '%s%s second'))" ; break ; case 'pgsql' : $ date = ( "(" . "now() at time zone 'utc' %s " . "interval '%s second'" . ")::timestamp(0)" ) ; break ; case 'mysql' : # mysql cannot accept function default; do # not use this on DDL $ date = ( "(date_add(utc_timestamp(), interval %s%s second))" ) ; break ; } return sprintf ( $ date , $ sign , $ delta ) ; }
SQL datetime fragment.
SQL datetime fragment .