I have a MySQL table 'notes' which has two columns, 'last_update' and 'created', of data type DATETIME. They're defined as follows:
But when I connect to the database via Strata and open that table, the 'last_update' and 'created' columns look like this:
Note the slight oddness in the 'last_update' column.
I'm not sure what causes this; it's been the case since I first opened the table in Strata, and nothing I do in terms of sorting, filtering, changing the column's data type, &c. changes it. It doesn't seem to affect any of the other tables I have which contain DATETIME columns, but other than that I'm still testing to see if I can narrow it down any. If I find anything useful, I'll edit it into the post. (Yeah, I found the button for that, finally. :)
Hope this helps!