TIMESTAMP column misrepresented
Brought to you by:
lorenztextor,
skrysakj
Querying a table with a TIMESTAMP column (default
CURRENT_TIMESTAMP) always displays NULL, even when there is a
valid timestamp in the field. This affects Content (browse table),
Custom Query and File Export. The true timestamp may be
retrieved by performing an operation on the column, e.g. "SELECT
UNIX_TIMESTAMP(updated) FROM mytable" gives the correct value,
while "SELECT updated FROM mytable" returns NULL.
Logged In: YES
user_id=209930
I can confirm this, but it probably didn't need confirmation. :-)