function date_sql_concat in Date 7.2

Same name and namespace in other branches

1. 8 date_api/date_api.module \date_sql_concat()
2. 5.2 date_api_sql.inc \date_sql_concat()
3. 5 date.inc \date_sql_concat()
4. 6.2 date_api_sql.inc \date_sql_concat()
5. 6 date_api_sql.inc \date_sql_concat()
6. 7.3 date_api/date_api_sql.inc \date_sql_concat()
7. 7 date_api/date_api_sql.inc \date_sql_concat()

A helper function to do cross-database concatation of date parts.

Parameters

array $array: An array of values to be concatonated in SQL.

Return value

string Correct SQL string for database type.

File

date_api/date_api_sql.inc, line 22

SQL helper for Date API.

Code

function date_sql_concat(array $array) {
  switch (Database::getConnection()
    ->databaseType()) {
    case 'mysql':
      return "CONCAT(" . implode(",", $array) . ")";
    case 'pgsql':
      return implode(" || ", $array);
  }
}