Welcome, Guest
Please Login or Register.    Lost Password?
Kunena
Table JX
Installation

Data Format
(1 viewing) (1) Guest
Welcome to the ToolsJX forum!
Go to bottomPage: 1
TOPIC: Data Format
#331
Data Format 5 Months ago Karma: 0
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
daverodhouse
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#333
Re:Data Format 5 Months ago Karma: 1
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
viljem
Admin
Posts: 145
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1
Kunena
Table JX
Installation
Powered by Kunenaget the latest posts directly to your desktop
Tools JX, Powered by Joomla!; Joomla templates by SG web hosting