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

  • Stumbling upon a really nice ProcessWire-powered website, plus core updates including API improvements for ProcessWire forms— More
    9 September 2022
  • Useful new dot-and-bracket syntax options added for page.get() method— More
    2 September 2022
  • This week, in addition to the regular core updates, we have new versions of ProcessWire ProFields Table and ProFields Combo that add support for their own file and image types— More
    19 August 2022

Latest news

  • ProcessWire Weekly #437
    In the 437th issue of ProcessWire Weekly we're going to check out the latest core updates, forum highlights and online resources, and more. Read on! / 24 September 2022
  • Multi-language field translation export/import
    In this post we cover the details of a new module that enables export and import capabilities for multi-language fields in ProcessWire.
    Blog / 5 August 2022
  • Subscribe to weekly ProcessWire news

“Indeed, if ProcessWire can be considered as a CMS in its own right, it also offers all the advantages of a CMF (Content Management Framework). Unlike other solutions, the programmer is not forced to follow the proposed model and can integrate his/her ways of doing things.” —Guy Verville, Spiria Digital Inc.