I am using TW 6.x-1.2 with Views 6.x-2.11 on MySQL table that contains 2 datetime fields. TW is no longer formatting the datetime fields properly. This worked properly for the past year or so until I did an update to TW 6.x-1.2 4 weeks ago. The datetime fields are correct in the database and display properly in several other locations when used through custom modules. All 5 million records in the table display the same time, 12/31/1969 - 8:33pm, when viewed through TW and Views.

There appears to be at least one other complaint like this at http://drupal.org/node/819072.

Thanks,
Elmer.

Comments

overaph’s picture

overaph commented

I found same error.
My date fields show the same value:
01/01/1970 - 02:33

any idea for fix this?

mikeryan’s picture

mikeryan
he/him
Primary language English
Location Pittsfield, MA, USA
commented
Status: Active » Fixed

_tw_views_handler() was setting date handlers for these fields - unfortunately, those handlers assume they're dealing with Unix timestamps rather than true date fields. Backed it out to treat datetime fields like strings - this will probably make other datetime stuff harder, but fixes the straightforward case you're seeing.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.