How do I use DateTime columns in wpDataTables?

DateTime columns handle values that contain both a date and a time, rendering them in the format specified on the wpDataTables settings page.

• Rendering rules: values are cast as date and time, then formatted per the plugin settings.
• Sorting rules: datetime-based sorting.
• Applicable filter types: datetime range.

Issues to note:

• When working with Excel files, it is best to set the format of DateTime columns as plain text, since the PHPSpreadsheet library that parses Excel files does not parse all Excel date formats correctly.
• When using MySQL, cast timestamp columns to datetime to avoid problems.
• Global search does not support datetime searching.

In the example, a football match table has a “Date & time” column showing entries like 22/10/2020 01:30 PM alongside team and stadium information.

• Creating editable tables and filling table data manually
• Creating non-editable tables from Excel files
• Creating non-editable tables from Google Spreadsheets
• String (text) columns
• Integer columns
• Float columns
• Date columns
• Time columns
• Image columns
• URL link columns
• E-mail link columns
• Currency/price columns
• Formula (calculated) columns
• Coloring and styling columns
• Hiding (dynamic) columns
• Column types overview