Skip to content

Time Rules

Time values are encoded in data table files using Khiops native format HH:MM:SS.. Other formats are available, that allow to convert categorical values to time values. The . at the end of the format means that fractions of seconds are optional. The use of parenthesis in time formats means that the corresponding digit is optional when it is null (e.g. 9:30:8 with format (H)H:(M)M:(S)S corresponds to 09:30:08 with format HH:MM:SS):
HH:MM:SS HH:MM:SS. HH:MM
HH.MM.SS HH.MM.SS. HH.MM
(H)H:(M)M:(S)S (H)H:(M)M:(S)S. (H)H:(M)M
(H)H.(M)M.(S)S (H)H.(M)M.(S)S. (H)H.(M)M
HHMMSS HHMMSS. HHMM

Valid times range from 00:00:00 to 23:59:59, with optional fractions of seconds up to 1/10000 of a second. Time rules return a missing value when their time operand is not valid or when a numerical operand is missing.

FormatTime

Categorical FormatTime(Time value, Categorical timeFormat)

Formats a time into a categorical value using a time format. Time format is a categorical constant value among the available time formats (for example: HH:MM:SS).

AsTime

Time AsTime(Categorical timeString, Categorical timeFormat)

Recodes a categorical value into a time using a time format.

Example

AsTime(“18:25:00”, “HH:MM:SS”)

Hour

Numerical Hour(Time value)

Hour in a time value.

Minute

Numerical Minute(Time value)

Minute in a time value.

Second

Numerical Second(Time value)

Second in a time value.

DaySecond

Numerical DaySecond(Time value)

Total second in a time value, since 00:00:00.

DecimalTime

Numerical DecimalTime(Time value)

Decimal day in a time value, between 0.0 and 23.9999.

Precisely, DecimalTime := DaySecond/(24 * 60 * 60).

DiffTime

Numerical DiffTime(Time value1, Time value2)

Difference in seconds between two time values.

IsTimeValid

Numerical IsTimeValid(Time value)

Checks if a time value is valid.

BuildTime

Time BuildTime(Numerical hour, Numerical minute, Numerical second)

Builds a time value from hour, minute and second.

The rule uses the floor value of hour and minute, and the full value of second. The hour must be between 0 and 23. The minute must be between 0 and 59. The second must be between 0 and 59, with optional fraction of second.