Please wait...

Time columns in wpDataTables

Video versionA video overview of time columns in wpDataTables

Time columns in wpDataTablesTime column type and when to use it

The “Time” column type is used for values that contain hours and minutes. Time columns will render the time values in the format you specify on the“wpDataTables settings“ page. Two format types are available:

  1. 1:25 PM (12hour)
  2. 13:25 (24hour)
  • Rendering rules: the value is cast as time, and then formatted using the format defined in the plugin settings.
  • Sorting rules: time.
  • Applicable filter types: time range.
  • Issues to note:
    • Seconds are not yet supported.
    • Global search doesn’t support search by time.

ExampleA demo table that has Time columns in it

Arrival” column in this table is of Time type.

wdt_ID Flight Carrier Origin Arrival Term. Status
1 AV 42 AVIANCA (MDE) Medellin 06:13 AM 4 Landed  Delayed
2 NH 7814 ANA (MDE) Medellin 06:13 AM 4 Landed  On-time
3 AS 18 Alaska Airlines (SEA) Seattle 05:20 AM 8 Landed  On-time
4 AA 7039 American Airlines (SEA) Seattle 05:20 AM 8 Landed  On-time
5 DL 2619 Delta Air Lines (LAS) Las Vegas 05:45 AM 4 Landed  On-time
6 KL 6649 KLM (LAS) Las Vegas 05:45 AM 4 Landed  On-time
7 VS 4770 Virgin Atlantic (LAS) Las Vegas 05:45 AM 4 Landed  On-time
8 JJ 8414 LATAM Airlines Brasil (GIG) Rio De Janeiro 05:39 AM 8 Landed  On-time
9 CX 7713 Cathay Pacific (GIG) Rio De Janeiro 05:39 AM 8 Landed  On-time
10 AA 974 American Airlines (GIG) Rio De Janeiro 05:36 AM 8 Landed  On-time
wdt_ID Flight Carrier Origin Arrival Term. Status

Never miss new features!

Join 3000+ newsletter subscribers

Never miss notifications about new cool features, promotions, giveaways or freebies - subscribe to our newsletter! We send about one mail per month, and do our best to keep our announcements interesting.

By clicking "subscribe" you consent that the information you provide via this form will be securely processed and stored in compliance with EU privacy laws (GDPR).
This  information will be used to send you newsletters as well as pre-populate any forms, should you want to edit your newsletter preferences.
You can always use this link to unsubscribe from the newsletter. You can see our Privacy Policy here.