function date_sql_pad in Date 6.2

Same name and namespace in other branches

1. 8 date_api/date_api.module \date_sql_pad()
2. 5 date.inc \date_sql_pad()
3. 6 date_api_sql.inc \date_sql_pad()
4. 7.3 date_api/date_api_sql.inc \date_sql_pad()
5. 7 date_api/date_api_sql.inc \date_sql_pad()
6. 7.2 date_api/date_api_sql.inc \date_sql_pad()

A helper function to do cross-database padding of date parts

Parameters

$str - a string to apply padding to: @param $size - the size the final string should be @param $pad - the value to pad the string with @param $side - the side of the string to pad

File

./date_api_sql.inc, line 47

SQL date functions.

Code

function date_sql_pad($str, $size = 2, $pad = '0', $side = 'l') {
  switch ($side) {
    case 'r':
      return "RPAD({$str}, {$size}, '{$pad}')";
    default:
      return "LPAD({$str}, {$size}, '{$pad}')";
  }
}