Data Format

Hi

I have some date fields in my data, which are stored in yyyy-mm-dd format, but i want it to display as dd-mm-yyyy, is there a way to do this?

Many thanks

Hi,

in admin section there is no option yet to apply cell data type formating. Probably we will include that in next releases.

The solution:
Create view in phpMyAdmin and show view with TableJX.

CREATE VIEW Something AS
SELECT DATE_FORMAT(yourDate, '%d %m %Y')
FROM YourTable

Please see also reference manuals for mysql:
dev.mysql.com/doc/refman/5.1/en/date-and...function_date-format

Best regards,
Viljem