https://antibiotiqueaugmentin.com/surdosage-augmentin-bebe/
× Welcome to the ToolsJX forum!


Date format on Table JX

  • dellison1226
  • dellison1226's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
10 years 2 months ago #2758

Table JX is working fine but when data is pulled the date format looks just like it is from the database.

Ex: 2014-05-31 21:00:00

Is there anything that can be done to get the date to format like this?

Ex: May 31, 2014 9:00pm

Thank you,
David

Please Log in or Create an account to join the conversation.

More
10 years 2 months ago #2759

Hi,

this is because the data is from the database. =)

Currently Table JX itself is not able to handle any date or numerical formatting. What you can do is to create a database view and handle the data formatting there. Here is an article describing in short how to use database views with Table JX.

toolsjx.com/faq/3-how-to-create-a-databa...use-it-with-tools-jx

Also take a look at date formatting functions of MYSQL:

dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html

Please Log in or Create an account to join the conversation.

  • dellison1226
  • dellison1226's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
10 years 2 months ago #2762

Thank you

Please Log in or Create an account to join the conversation.

Moderators: tomaz
Time to create page: 0.153 seconds

Contact Us

Contact us on Discord

Contact us on Facebook