revert changes made because of bug-for-bug compatibility
add timezone information and proper datatypes to timestamps