The datetime data type

For example, the qualifier in the following declaration is year to day:

datetime year to day sale;

As a host variable, a dtime_t. structure represents a datetime value:

typedef struct dtime {
   short dt_qual;
   dec_t dt_dec;
} dtime_t;

The dtime structure and dtime_t typedef have two parts. The following table lists these parts.

Table 1. Fields in the dtime structure

Field	Description
dt_qual	Qualifier of the datetime value
dt_dec	Digits of the fields of the datetime value This field is a decimal value.

Declare a host variable for a DATETIME column with the datetime data type followed by an optional qualifier, as the following example shows:

EXEC SQL include datetime;
;

EXEC SQL BEGIN DECLARE SECTION;
   datetime year to day holidays[10];
   datetime hour to second wins, places, shows;
   datetime column6;
EXEC SQL END DECLARE SECTION;