InputfieldTime by Netcarver

Adds a fieldtype and Inputfield for MySQL TIME fields.

FieldtypeTime & InputfieldTime

Modules for ProcessWire that allow easy input of times in various formats. The value is stored in the DB as an SQL time field with values between about +800:00:00 and -800:00:00 but the display and input format can be chosen by the user.

Supported Input/Display formats

The following input and display formats are supported.

  • 'HH24' Hours (0-24)
  • 'HH24MM' Hours (0-24) & minutes (00-59)
  • 'HH24MMSS' Hours (0-24), minutes (00-59) & seconds (00-59)
  • 'HHH' Hours (Integer 0-800)
  • 'HHHMM' Hours (0-800) & minutes (00-59)
  • 'HHHMMSS' Hours (0-800), minutes (00-59) & seconds (00-59)
  • 'MMM' Minutes (Integer)
  • 'SSS' Seconds (Integer)
  • 'MMSS' Minutes (00-59) & seconds (00-59).

The fieldtype will use the chosen format to work out if actual input is incomplete and try to autocomplete the missing parts. For example, if you have a field setup to HH24MM and only type '9' into the Inputfield the fieldtype will assume you mean '09:00' (that is, 9 in the morning) and use that as the final value.

You can configure if colons are to be used between parts in the displayed output. So you can choose between '0900' and '09:00'.

Comparison in selectors

If you wish to use a formatted time in a selector then you need to have the time in your selector string use the DB formatting of 'HH:MM:SS' as the comparison is done by the DB. You can use the date() function directly or you can use the utility function formattedStringToTime()...

// For a value with Hours and Mins...
$selector_time_string = date('H:m:00', $time); // or...
$selector_time_string = FieldtypeTime::formattedStringToTime(date('H:m', $time), 'HH24MM');

It will often be easier to work with date() directly.

Install and use modules at your own risk. Always have a site and database backup before installing new modules.

Twitter updates

  • ProcessWire 3.0.185 (dev) core updates, plus new Session Allow module— More
    17 September 2021
  • Three new ProcessWire Textformatter modules: Find/Replace, Markdown in Markup, and Emoji— More
    3 September 2021
  • This week we have a new master version released after a year in the making. With nearly 40 pull requests, hundreds of new additions and more than 100 issue reports resolved, this new version has a ton of great new stuff— More
    27 August 2021

Latest news

  • ProcessWire Weekly #385
    In the 385th issue of ProcessWire Weekly we'll cover the latest weekly update from Ryan, check out a new fieldtype module called Page Reference Context Data, and more. Read on! / 25 September 2021
  • ProcessWire 3.0.184 new master/main version
    This week we have a new master/main version released after a full year in the making. As you might imagine, this new version has a ton of great new stuff and we’ll try to cover much of it here.
    Blog / 27 August 2021
  • Subscribe to weekly ProcessWire news

“Yesterday I sent the client a short documentation for their ProcessWire-powered website. Today all features already used with no questions. #cmsdoneright—Marc Hinse, Web designer/developer