Data types - 23.1

spectrum-inline

Product type
Software
Portfolio
Enrich
Integrate
Locate
Verify
Product family
Spectrum
Product
Spectrum > Discovery
Spectrum > Web Services
Spectrum > Dataflow Designer
Spectrum > Geo Addressing > Enterprise Tax
Spectrum > GeoEnrichment
Spectrum > Data Integration
Spectrum > Quality > Context Graph
Spectrum > Spectrum Platform
Spectrum > Quality > Addressing
Spectrum > Spatial > Spectrum Spatial
Spectrum > Quality > Spectrum Quality
Version
23.1
Language
English
Product name
Precisely Spectrum
Title
spectrum-inline
First publish date
2007
Last updated
2023-06-02
Published on
2023-06-02T09:54:39.526000

Spectrum Technology Platform supports these data types.

bigdecimal
A numeric data type that supports 38 decimal points of precision. Use this data type for data that will be used in mathematical calculations requiring a high degree of precision, especially those involving financial data. The bigdecimal data type supports more precise calculations than the double data type.
boolean
A logical type with two values: true and false.
bytearray
An array (list) of bytes.
Note: Bytearray is not supported as an input for a REST service.
date
A data type that contains a month, day, and year. For example, 2012-01-30 or January 30, 2012. You can specify a default date format in Spectrum Management Console.
datetime
A data type that contains a month, day, year, and hours, minutes, and seconds. For example, 2012/01/30 6:15:00 PM.
double
A numeric data type that contains both negative and positive double precision numbers between 2-1074 and (2-2-52)×21023. In E notation, the range of values is -1.79769313486232E+308 to 1.79769313486232E+308.
float
A numeric data type that contains both negative and positive single precision numbers between 2-149 and (2-223)×2127. In E notation, the range of values -3.402823E+38 to 3.402823E+38.
integer
A numeric data type that contains both negative and positive whole numbers between -231 (-2,147,483,648) and 231-1 (2,147,483,647).
list
Strictly speaking, a list is not a data type. However, when a field contains hierarchical data, it is treated as a "list" field. In a list is a collection of data consisting of multiple values. For example, a field Names may contain a list of name values. This may be represented in an XML structure as:
<Names>
    <Name>John Smith</Name>
    <Name>Ann Fowler</Name>
</Names>
It is important to note that the list data type different from the XML schema list data type in that the XML list data type is a simple data type consisting of multiple values, whereas the list data type is similar to an XML complex data type.
long
A numeric data type that contains both negative and positive whole numbers between -263 (-9,223,372,036,854,775,808) and 263-1 (9,223,372,036,854,775,807).
string
A sequence of characters.
time
A data type that contains the time of day. For example, 21:15:59 or 9:15:59 PM.