String Parameter ODBCDateTimeFormat

ODBCDateTimeFormat

The predefined string parameter ODBCDateTimeFormat defines, for each identifier within an AIMMS model, the date-time conversion string.

StringParameter ODBCDateTimeFormat {
    IndexDomain  :  IndexIdentifiers;
}

Definition

The string parameter ODBCDateTimeFormat defines, for each identifier within an AIMMS model, the date-time format string, which AIMMS will use in converting AIMMS data to date-time columns in a database table and vice versa.

Updatability

The data of ODBCDateTimeFormat can be modified both from within the model and the end-user interface.

Note

The use of ODBCDateTimeFormat to convert AIMMS data to date-time columns and vice versa, are not necessary for columns which are mapped onto AIMMS calendars. In that case, AIMMS is able to determine the conversion itself based on the timeslot format specified for the calendar.

See also

The use of ODBCDateTimeFormat is discussed in more detail in Dealing with Date-Time Values of the Language Reference. The format to which values of ODBCDateTimeFormat should comply are discussed in Format of Time Slots and Periods