1.1

Example
CREATE TABLE clob_data(id INT primary key, text CLOB(10M));
–- search for a clob
select text from clob_data where id = 100;
DATE
Provides for storage of a date as year-month-day. Supported formats are:
yyyy-mm-dd
mm/dd/yyyy
dd.mm.yyyy
The year (yyyy) must always be expressed with four digits, while months (mm) and days (dd) may have either
one or two digits. DATEs, TIMEs, and TIMESTAMPs must not be mixed with one another in expressions except
with an explicit CAST.
java.sql.DateEquivalent Java type
java.sql.Types.DATEJDBC metadata type
ResultSet.getDate, PreparedStatement.setDateJDBC methods
System.DateTimeEquivalent .NET type
Vmware.Data.SQLFire.SQLFType.DateADO.NET metadata type
DateADO.NET mapped System.Data.Dbtype
DbDataReader.GetDateTimeADO.NET getter
Example
VALUES '2010-05-04'
VALUES DATE('2001-10-12')
The latter example uses the DATE() function described in the section Built-in functions and procedures.
DECIMAL
Provides an exact decimal value having a specified precision and scale. The precision is the total number of
digits both to the left and the right of the decimal point, and the scale is the number of digits in the fraction to
the right of the decimal point.
A numeric value (e.g. INT, BIGINT, SMALLINT) can be put into a DECIMAL as long as non-fractional precision
is not lost else a range exception is thrown (SQLState: “22003”). When truncating trailing digits from a DECIMAL,
the value is rounded down.
For behavior with other types in expressions, see Numeric type promotion in expressions, Scale for decimal
arithmetic and Storing values of one numeric data type in columns of another numeric data type.
java.math.BigDecimalEquivalent Java type
1 to 31Precision min/max
less than or equal to precisionScale min/max
5Default precision
607
SQL Language Reference