When reading data from the database the following datatypes are supported, with conversion to the corresponding prolog datatypes.
A list of character codes.
0 for false, or
1 for true.
A floating point number.
date(Year, Month, DayOfMonth), with one-based
integer arguments. E.g.
date(2012,10,22) means October
time(Hour, Minute, Second) with one-based integer
time(22,11,5) means eleven minutes and
five seconds past ten pm.
timestamp(Year, Month, Day, Hour, Minute, Second,
Fraction) where the arguments have the same meaning as for
SQL_TIMESTAMP and Fraction
means fractional nanoseconds past, as an integer.
SQL_BINARYand other binary types
SQL_INTERVAL_HOURand other interval types
Currently not supported.
Note that atoms with names that start with an upper case letter,
SQL_CHAR must be quoted in Prolog, e.g.