You can convert a DATE value to the following numeric types with either the CAST statement or Teradata conversion syntax:
- BYTEINT
- SMALLINT
- INTEGER
- BIGINT
- DECIMAL (n, m)
- NUMBER
- FLOAT