remove the time part when createODBCDate is called, not when the date is converted to something else, based on the timezone available at this time.
added testcase for ticket 2880
if a number offset is not allowd interpret numbers as years