From 475c331f6079dacb4fd21ebb3e4e53b021075c3f Mon Sep 17 00:00:00 2001 From: Roan Kattouw Date: Fri, 31 Dec 2010 16:29:44 +0000 Subject: [PATCH] Remove now-unused SQL timestamp conversion functions added in r77231. They were made obsolete by the querypage-work2 branch merge in r78786 --- includes/db/Database.php | 10 ---------- includes/db/DatabaseMssql.php | 4 ---- includes/db/DatabaseMysql.php | 3 --- includes/db/DatabaseOracle.php | 4 ---- includes/db/DatabaseSqlite.php | 4 ---- 5 files changed, 25 deletions(-) diff --git a/includes/db/Database.php b/includes/db/Database.php index e8b7c6002b..95d572f325 100644 --- a/includes/db/Database.php +++ b/includes/db/Database.php @@ -2044,16 +2044,6 @@ abstract class DatabaseBase implements DatabaseType { return "REPLACE({$orig}, {$old}, {$new})"; } - /** - * Convert a field to an unix timestamp - * - * @param $field String: field name - * @return String: SQL statement - */ - public function unixTimestamp( $field ) { - return "EXTRACT(epoch FROM $field)"; - } - /** * Determines if the last failure was due to a deadlock * STUB diff --git a/includes/db/DatabaseMssql.php b/includes/db/DatabaseMssql.php index 4f09069f3e..aa6212b096 100644 --- a/includes/db/DatabaseMssql.php +++ b/includes/db/DatabaseMssql.php @@ -787,10 +787,6 @@ class DatabaseMssql extends DatabaseBase { return false; } - public function unixTimestamp( $field ) { - return "DATEDIFF(s,CONVERT(datetime,'1/1/1970'),$field)"; - } - /** * Begin a transaction, committing any previously open transaction */ diff --git a/includes/db/DatabaseMysql.php b/includes/db/DatabaseMysql.php index 7ecc3de9ad..e6bd2b2cfe 100644 --- a/includes/db/DatabaseMysql.php +++ b/includes/db/DatabaseMysql.php @@ -478,9 +478,6 @@ class DatabaseMysql extends DatabaseBase { $this->query( "SET sql_big_selects=$encValue", __METHOD__ ); } - public function unixTimestamp( $field ) { - return "UNIX_TIMESTAMP($field)"; - } /** * Determines if the last failure was due to a deadlock diff --git a/includes/db/DatabaseOracle.php b/includes/db/DatabaseOracle.php index 8893e2ef21..00be0f1404 100644 --- a/includes/db/DatabaseOracle.php +++ b/includes/db/DatabaseOracle.php @@ -839,10 +839,6 @@ class DatabaseOracle extends DatabaseBase { return 'SELECT * ' . ( $all ? '':'/* UNION_UNIQUE */ ' ) . 'FROM (' . implode( $glue, $sqls ) . ')' ; } - public function unixTimestamp( $field ) { - return "((trunc($field) - to_date('19700101','YYYYMMDD')) * 86400)"; - } - function wasDeadlock() { return $this->lastErrno() == 'OCI-00060'; } diff --git a/includes/db/DatabaseSqlite.php b/includes/db/DatabaseSqlite.php index 92b8124fc4..1058fd804f 100644 --- a/includes/db/DatabaseSqlite.php +++ b/includes/db/DatabaseSqlite.php @@ -431,10 +431,6 @@ class DatabaseSqlite extends DatabaseBase { return implode( $glue, $sqls ); } - public function unixTimestamp( $field ) { - return $field; - } - function wasDeadlock() { return $this->lastErrno() == 5; // SQLITE_BUSY } -- 2.20.1