Hello, I need datetime format dd.mm.yyyy hh:mm:ss, now seconds are missing. I need time format hh:mm:ss.000, now seconds and milliseconds are missing.Thanks.
Sorry but I did not quite understand what are you trying to achieve.
Can you please explain me more and send me some example/screenshot so I can give you my suggestion.
Only workaround what Datetime with seconds would work is to have MySQL table with data. Times will be displayed with seconds and sorting will work but editing from WP backed is not possible. You will have to edit this time values directly in database.
Steps you need to follow to achieve this:
Have to go in database, find table wp_options. In this table find wdtTimeFormatin option_name column and set h:i:s as option_value for this column.
After that you have to create new MySQL table where you will place data. This table will be called "datetime_table" in this example, and one of the column (or more then one it depends how much datetime columns do you need) will be DATETIME type:
Then when you created a table in database, you'll have to create wpDataTable based on datetime_table from database, and you can create it if you choose Add From Data Source and select MySQL table. Your query should be:
SELECT * FROM datetime_table
Like that you'll show datetime with second and will be able to sort it, but only way to edit data is directly from the database. Column type for this column should be Datetime in optional column setup.
Hello, I need datetime format dd.mm.yyyy hh:mm:ss, now seconds are missing. I need time format hh:mm:ss.000, now seconds and milliseconds are missing.Thanks.
Hi jiri,
Thank you for your purchase.
Sorry but I did not quite understand what are you trying to achieve. Can you please explain me more and send me some example/screenshot so I can give you my suggestion.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Milan,
please see picture.
Thanks
Hi jiri,
Only workaround what Datetime with seconds would work is to have MySQL table with data. Times will be displayed with seconds and sorting will work but editing from WP backed is not possible. You will have to edit this time values directly in database.
Steps you need to follow to achieve this:
Have to go in database, find table wp_options. In this table find wdtTimeFormatin option_name column and set h:i:s as option_value for this column.
After that you have to create new MySQL table where you will place data. This table will be called "datetime_table" in this example, and one of the column (or more then one it depends how much datetime columns do you need) will be DATETIME type:
Then when you created a table in database, you'll have to create wpDataTable based on datetime_table from database, and you can create it if you choose Add From Data Source and select MySQL table. Your query should be:
Like that you'll show datetime with second and will be able to sort it, but only way to edit data is directly from the database. Column type for this column should be Datetime in optional column setup.
Unfortunately , milliseconds are not supported.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Milan,
it's perfect for my purposes. Thank you very much for your advice.
If I need milliseconds, I'll show them in a separate column.
Thanks
Hi jiri,
You are welcome. Glad that we solved the issue.
If you have any more issues feel free to open a new ticket, we will gladly help.
We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables