Finally found source of Missing join error message, don't add relationship if the the date is in the base table.

I can finally get rid of the double % in date format strings since it no longer gets passed through db_rewrite_query() so doesn't need that extra escape character.

Remove database timezone handling by rolling back to previous version that used offsets instead. Based on problems noted in #218479 and #220663, we cannot count on database timezone handling to be available in MYSQL or work consistently with the timezone names that PHP uses in POSTGRES, so trying to do timezone conversions in the database is not going to work.

Synch with D5.2 version.

Getting rid of offsets!! Alter query code to cast ISO and UNIX dates to native datetimes and do timezone conversion in the database. Much faster and more accurate.

This will mean this version of the code will not work for databases that are not able to do native timezone conversion, but even inexpensive shared hosts will probably have the MYSQL database timezone tables installed, and PostgreSQL has good timezone handling enabled by default.

The MYSQL timezone conversion code should be accurate, the PostgreSQL code looks right from the documentation but needs to be verified.

The offset fields can now be dropped from the Date fields since we only need the timezone name to do the conversion.

I probably missed some places that need to be adjusted for this change, but this should get most of the necessary fixes in place.

Build in ability to do native db timezone adjustments in queries, won't work until we have a native datetime field in the database.

Very preliminary rewrite of Date API to become version 5.2. Not ready to be used yet! Still coming is rewrite of date and calendar module to use new API.