1. Create a column (for example "Updated") in your table
2. In column settings set the type to be "DateTime" (in the "Data" tab), and in the "Editing" tab set the "Editor Input Type" to "none".
3. In the database, run this query:
ALTER TABLE `table_name` CHANGE `updated` `updated` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
Please note that you need to replace 'table_name' with the actual database table name. You can find the database name of the table in the Editing tab above the table, in the "MySQL query name for editing" field.
Thnx for the quick answer. Im not a sql person so i dont know how to do it. I have done what you tell me to do. i made a kolum :updated en set it to date/time and edit to non.
I have made the query in myadminphp and now? i dont know what i am missing. The time i the results (lap time) kolum is stil the wrong format
Kolom: Date | Kolom: distance | Kolom: Time Row: 14-5-2022 | Row: 25MTR | row: 00:00:01:22
Above the table i want a line chart so i can make it visable If i make my dreams come true for him then the time kolom become green when the time meets the prerequisite he need to get a ticket for the finals. so lets say the prerequisite are a time between 00:00:01:01 and 00:00:00:45 and his time is 00:00:00:59 then the cell is green, if not then it has no color
I hope that you understand what i try to do So i can track his progress as he is training for the national title. This Year he was 4e :)
Unfortunately, this is currently not possible with wpDataTables' built-in features to display milliseconds. We carefully follow customers' requirements and try to implement most of them if they appear in requests from time to time, so we will add them to our idea list and look into some possible solutions on the plugin side in the future.
We constantly strive to make our product better, and deliver the most value for our end users - so please share your feedback on what features you need on this link.
Hi,
is it possible to change the time format in a cell to HH:mm:ss:ms so i get hour-minute-seconds-milliseconds?
I need this for the swim sport of my son. I really need to create a chart were i can track his times and make it visual in a chart
Is your plugin has not that option, is there a snippet i can use?
Hello Bert,
Thank you for reaching out to us.
1. Create a column (for example "Updated") in your table
2. In column settings set the type to be "DateTime" (in the "Data" tab), and in the "Editing" tab set the "Editor Input Type" to "none".
3. In the database, run this query:
Please note that you need to replace 'table_name' with the actual database table name. You can find the database name of the table in the Editing tab above the table, in the "MySQL query name for editing" field.
Kind Regards,
Uros Jovanovic
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Uros,
Thnx for the quick answer. Im not a sql person so i dont know how to do it.
I have done what you tell me to do. i made a kolum :updated en set it to date/time and edit to non.
I have made the query in myadminphp and now? i dont know what i am missing. The time i the results (lap time) kolum is stil the wrong format
This what i need to have as result.
Kolom: Date | Kolom: distance | Kolom: Time
Row: 14-5-2022 | Row: 25MTR | row: 00:00:01:22
Above the table i want a line chart so i can make it visable
If i make my dreams come true for him then the time kolom become green when the time meets the prerequisite he need to get a ticket for the finals. so lets say the prerequisite are a time between
00:00:01:01 and 00:00:00:45 and his time is 00:00:00:59 then the cell is green, if not then it has no color
I hope that you understand what i try to do So i can track his progress as he is training for the national title. This Year he was 4e :)
Hello Bert,
Thank you for your patience.
Unfortunately, this is currently not possible with wpDataTables' built-in features to display milliseconds. We carefully follow customers' requirements and try to implement most of them if they appear in requests from time to time, so we will add them to our idea list and look into some possible solutions on the plugin side in the future.
We constantly strive to make our product better, and deliver the most value for our end users - so please share your feedback on what features you need on this link.
Kind Regards,
Uros Jovanovic
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables