PG 8.3 tightened up type checking, thus enforcing the notion that "to_date" converts a string to a date, not a date to another form of a date (sheesh).
Moved that query into the pg xql file then discovered that apparently it's not a good query for oracle, either, so hopefully fixed that (though it will need testing)