In Postgres views filtering dates compares 2 digit years to 4 digit years

When you use try to filter a view by date (in postgres) you end up with a query filter like
(TO_CHAR(TO_DATE(node_data_field_date_availible.field_date_availible_value, 'FMYYYY-FMMM-FMDDTFMHH:FMMI:FMSS'), 'YY-MM-DD') >= '2008-11-28')
which causes a problem because 2008-11-28 is of the form YYYY-MM-DD.

Easiest way to fix this is to change sql_format() in date_api_sql.inc where you have
'Y' => 'YY', 'y' => 'Y',
change the line to
'Y' => 'YYYY', 'y' => 'Y',

patch attached

Thanks,
Steven H. Noble