See video version of the tutorial

DateTime column type is used for values that contain both date and time parts. DateTime columns will render the date and time values in the format that you specify on the plugin settings page.

  • Rendering rules: value is casted as a date and time, then formatted using the format defined in the plugin settings.
  • Sorting rules: datetime.
  • Applicable filter types: datetime range.
  • Issues to note:
    • When working with Excel files it’s the best to set the format of DateTime columns as plain text; since PHPExcel library that parses Excel files does not parse the Excel date format correctly and this results in wrong rendering of the dates (usually they all get reset to 01/01/1970).
    • When you’re working with MySQL please cast timestamps columns to datetime to avoid problems.

Example:

“DateTime” column in this table is of DateTime type.

wdt_IDDateTimeHome TeamAway TeamStadium
122 Oct 2016 01:30 PMBournemouthTottenhamDean Court
222 Oct 2016 04:00 PMArsenalMiddlesbroughEmirates Stadium
322 Oct 2016 04:00 PMBurnleyEvertonTurf Moor
422 Oct 2016 04:00 PMHull CityStoke CityKCOM Stadium
522 Oct 2016 04:00 PMLeicester CityCrystal PalaceKing Power Stadium
622 Oct 2016 04:00 PMSwansea CityWatfordLiberty Stadium
722 Oct 2016 04:00 PMWest Ham UnitedSunderlandLondon Stadium
822 Oct 2016 06:30 PMLiverpoolWest Bromwich AlbionAnfield
923 Oct 2016 02:30 PMManchester CitySouthamptonEtihad Stadium
1023 Oct 2016 05:00 PMChelseaManchester UnitedStamford Bridge
wdt_IDDateTimeHome TeamAway TeamStadium


Never miss new features!

Join 2000+ 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.

We never spam or disclose your address to anyone.