Time Value

$Time function can be used within expressions to define a time value. The function call has the following parameters:

  1. Time constant or expression*. Default value is 00:00:00
  2. (optional) Time format, default is HH:MM:SS

* - functions call, expression or column-to-column references are acceptable as a value.

Example

  • $Time(0400,HHMM)
  • $Time(@'TimeColumn') - default format HH:MM:SS