Date/Time

The value derived from the function is in number of minutes.

This table shows the commands and the related syntax used for the Date/Time data type:

Command Syntax Examples
To_Date

The To_Date command converts a date or time string, formatted as defined by the format of the data type, into number of minutes.

To_Date(<Date/Time string>)
The format of the date or time string must be equal to the format of the data type.

 To_Date("12/12/2000 15:50:15")= number of minutes for this date

TimeCurMnt

This function returns the number of minutes for the current moment.

Operators

The result is in number of minutes, therefore all integer functions can be used to manipulate the result.

 ~ + 1440 (add a day)

~ + To_Date("12-12-2000 12:12:12") (sum of two dates)

 TimeCurMnt + 1440 (a day from now)