Index: includes/handlers.inc =================================================================== --- includes/handlers.inc (revision 46) +++ includes/handlers.inc (working copy) @@ -897,7 +897,7 @@ return "DATE_FORMAT($field, '$format')"; case 'pgsql': $replace = array( - 'Y' => 'YY', + 'Y' => 'YYYY', 'm' => 'MM', 'd' => 'DD', 'H' => 'HH24',