Duration

The duration field type is a numerical field type intended for storing time durations measured in hours, minutes, seconds and milliseconds.

Durations can be stored in five different formats that correspond to different degrees of granularity. These are:

  • h:mm: This format is used to store hours and minutes e.g. 2:33 (two hours and thirty three minutes)

  • h:mm:ss: This format is used to store hours, minutes and seconds e.g. 2:33.25 (two hours, thirty three minutes and 25 seconds)

  • h:mm:ss.s: This format is used to store hours, minutes, seconds and deciseconds e.g. 2:33.25.1 (two hours, thirty three minutes, 25 seconds and 1 deciseconds)

  • h:mm:ss.ss: This format is used to store hours, minutes, seconds and centiseconds e.g. 2:33.25.11 (two hours, thirty three minutes, 25 seconds and 11 centiseconds)

  • h:mm:ss.sss: This format is used to store hours, minutes, seconds and milliseconds e.g. 2:33.25.111 (two hours, thirty three minutes, 25 seconds and 111 milliseconds)

PreviousDatetimeNextEmail

Last updated