ODBC Reading - SICStus Prolog

When reading data from the database the following datatypes are supported, with conversion to the corresponding prolog datatypes.

SQL_CHAR, SQL_VARCHAR etc.: A list of character codes.
SQL_BIT: The integer 0 for false, or 1 for true.
SQL_INTEGER, SQL_TINYINT, SQL_SMALLINT, etc.: An integer.
SQL_REAL, SQL_DOUBLE, SQL_FLOAT: A floating point number.
SQL_DATE: A term date(Year, Month, DayOfMonth), with one-based integer arguments. E.g. date(2012,10,22) means October 22, 2012.
SQL_TIME: A term time(Hour, Minute, Second) with one-based integer arguments. E.g. time(22,11,5) means eleven minutes and five seconds past ten pm.
SQL_TIMESTAMP: A term timestamp(Year, Month, Day, Hour, Minute, Second, Fraction) where the arguments have the same meaning as for SQL_TIME and SQL_TIMESTAMP and Fraction means fractional nanoseconds past, as an integer.
the SQL null value: The atom null.
SQL_BINARY and other binary types
SQL_INTERVAL_HOUR and other interval types
SQL_UTCTIME and SQL_UTCDATETIME: Currently not supported.

Note that atoms with names that start with an upper case letter, like SQL_CHAR must be quoted in Prolog, e.g. 'SQL_CHAR'.