added time zone offset to the datetime values