SQL
Data Types
Metaform reads from data sources having a wide variety of types.
| SQL Data Type | Description | Example |
|---|---|---|
| BIGINT | 8-byte signed integer in the range -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 | 9223372036854775807 |
| BINARY | Variable-length byte string | B@e6d9eb7 |
| BOOLEAN | True or false | true |
| DATE | Years, months, and days in YYYY-MM-DD format since 4713 BC | 2015-12-30 |
| DECIMAL(p,s), or DEC(p,s), NUMERIC(p,s)* | 38-digit precision number, precision is p, and scale is s | DECIMAL(6,2) is 1234.56, 4 digits before and 2 digits after the decimal point |
| FLOAT | 4-byte floating point number | 0.456 |
| DOUBLE, DOUBLE PRECISION | 8-byte floating point number, precision-scalable | 0.456 |
| INTEGER or INT | 4-byte signed integer in the range -2,147,483,648 to 2,147,483,647 | 2147483646 |
| INTERVAL** | A day-time or year-month interval | '1 10:20:30.123' (day-time) or '1-2' year to month (year-month) |
| SMALLINT*** | 2-byte signed integer in the range -32,768 to 32,767 | 32000 |
| TIME | 24-hour based time before or after January 1, 2001 in hours, minutes, seconds format: HH:mm:ss | 22:55:55.23 The MASK function transforms the value of a column on each row. The function masks characters in a string, as shown by the following pseudo-code: |