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_IDFlightCarrierOriginArrivalTerm.Status
1AV 42AVIANCA(MDE) Medellin06:13 AM4Landed  Delayed
2NH 7814ANA(MDE) Medellin06:13 AM4Landed  On-time
3AS 18Alaska Airlines(SEA) Seattle05:20 AM8Landed  On-time
4AA 7039American Airlines(SEA) Seattle05:20 AM8Landed  On-time
5DL 2619Delta Air Lines(LAS) Las Vegas05:45 AM4Landed  On-time
6KL 6649KLM(LAS) Las Vegas05:45 AM4Landed  On-time
7VS 4770Virgin Atlantic(LAS) Las Vegas05:45 AM4Landed  On-time
8JJ 8414LATAM Airlines Brasil(GIG) Rio De Janeiro05:39 AM8Landed  On-time
9CX 7713Cathay Pacific(GIG) Rio De Janeiro05:39 AM8Landed  On-time
10AA 974American Airlines(GIG) Rio De Janeiro05:36 AM8Landed  On-time
wdt_IDFlightCarrierOriginArrivalTerm.Status

Do you have the best

essential plugins installed?

Grab the best 46 plugins. Tested and sorted.

Plugins for SEO, Caching, Security, Design and UX, Stats & analytics, Social sharing. Only the best ones.

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).

Thank you for subscribing! Please check your inbox to download the WordPress goodies.