#2645 text_plain__dateformat missinterpreting

[isy]

The PMA_transformation_text_plain__dateformat didn't interprete some unix time stamps correct.
e.g. the timestamp 1202137415
will be shown as 16-12-2012 02:15
but should be 04-02-2008 16:08

The problem may be in the line 37
if (preg_match('/^(\d{2}){3,7}$/', $buffer)) {

but i didn't got a solution ;-(

[isy]

Logged In: YES
user_id=1203504
Originator: YES

There is no option to automatically determin the time format correctly.
If I got a timestamp in the format:
1202131215 it is not possible to detect if this is a Timestamp in ascii format (e.g. yymmddHHMM) or an unix timestamp.
Therefore you must define an extra parameter for the PMA_transformation_text_plain__dateformat function.
e.g. extend the options with a fourth parameter which define the timestamp as ascii formated or as an unix integer timestamp (as default).

[Marc Delisle]

Logged In: YES
user_id=210714
Originator: NO

See this patch, present in 2.11.5-rc1
http://sourceforge.net/tracker/index.php?func=detail&aid=1879031&group_id=23067&atid=377410

[SourceForge Robot]

Logged In: YES
user_id=1312539
Originator: NO

This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).