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

Data Format
(1 viewing) (1) Guest
Welcome to the ToolsJX forum!
Go to bottom
Post Reply
Post New Topic
Page: 1
TOPIC: Data Format
#331
Data Format 1 Year, 11 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
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
daverodhouse
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#333
Re:Data Format 1 Year, 11 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
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
viljem
Admin
Posts: 181
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
Go to top
Post Reply
Post New Topic
Page: 1
Tools JX
Table JX
Installation
Moderators: tomaz
Powered by Kunenaget the latest posts directly to your desktop
Tools JX, Powered by Joomla!; Joomla templates by SG web hosting