Description

The date & time values are stored in a special Time variable. The data type Time in the Caravan database also has the same properties and can be accessed in the same manner as the Time variable.

The current date and time in the system can be accessed by declaring the time variable and accessing its sub components. The sub components of the time variable can even be assigned to temporary variables. The sub-components of the variable can be accessed as shown in the example. Use semi colons between subcomponents following each other.

Syntax

time now

"CURRENT DATE IS";now(date);"/";now(month);"/";now(year)

Back