Holiday Notice – Support Unavailable on April 18 and April 21
We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!
In the meantime, if you need any help, feel free to:
-
Use the support widget in the bottom right corner on our websites (Amelia and wpDataTables) — our latest AI-powered assistant is there 24/7 to help with basic and intermediate questions,
-
Browse our detailed documentation (Amelia, wpDataTables)
-
Explore helpful articles,
-
Or check out our YouTube channels for video guides!
Amelia YouTube Channel
wpDataTables YouTube Channel
Thank you for your understanding, and we wish you a wonderful holiday weekend!
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