BuiltIn Functions › $TIME Function

$TIME Function

$TIME returns an alphanumeric value with the specified or current time in the specified format.

This function has the following format:

$TIME ('time‑specification'[,TIME=time])

'time‑specification'

A sequence of characters (maximum 30) that represent components and notation of the time, as follows:

Component                                                    Example (Assuming
Notation    Meaning                                          (:03:08 am)

H           Hour without leading zeros
              (24‑hour clock)                               9
HH          Hour with leading zero                           09
PP          Hour with leading zero, (12‑hour          
              clock with AM/PM indication)                   09 AM
P           Same but without leading zero                    9 AM
MM          Minutes with leading zero                        03
SS          Seconds with leading zero                        08

Any character in the format, except uppercase alphabetics, remains unchanged. You must explicitly specify spacing and punctuation.

time

A six‑character alphanumeric literal in the format of 'HHMMSS' or a six‑character alphanumeric field with a value in that format. If you do not specify the TIME operand, the current time is used.

• The TIME operand must contain six digits in alphanumeric format.
• The TIME operand must be in the format 'HHMMSS', where 'HHMMSS' can be from 000000 to 240000. In this range, SS can be from 00 to 59, MM can be from 00 to 59, and HH can be from 00 to 23. The time is based on a 24‑hour clock that starts on 000000 (midnight), continues through 235959, and then resets to 000000. 240000 is also acceptable for midnight.
• If you omit the TIME operand, a call is generated to the operating system.

Examples

Assume that it is 9:03:08 am and FIELD contains 121336