datetime

Uniface data type that holds a sequence of numbers representing a date and time, in the format ccyymmddhhnnsstt.

datetime  ParameterName : Direction

datetime  VariableName

Use

Use in params and variables blocks to define the data type of a parameter or variable. The data type can be selected when defining fields, global variables, and component variables.

Description

For the Datetime data type, the following defaults apply for partial values:

  • If both the date and time have been omitted, the value is assumed to be NULL.
  • If the date has been omitted while a time is specified, the day, month and year default to the current day, the current month and the current year, respectively.
  • If an incomplete date is specified, a missing day defaults to 1, a missing month defaults to the current month, and a missing year defaults to the current year.

The $datim ProcScript function can be used to convert data to datetime.

Related Topics