Type conversion functions - Amazon IoT SiteWise
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Type conversion functions

Type conversion functions are used to change the data type of a value from one to another. They are essential for ensuring data compatibility and performing operations that require data in a specific format.

Function

Signature

Description

TO_DATE

  • TO_DATE (integer)

  • TO_DATE (expression, format)

  • Converts an epoch millisecond integer into a date value.

  • Converts a character string representation into a date value.

TO_TIMESTAMP

  • TO_TIMESTAMP (double)

  • TO_TIMESTAMP (string, format)

  • Converts an epoch second integer into a timestamp data type.

  • Converts a string representation of a date and time into a timestamp data type.

TO_TIME

  • TO_TIME (int)

  • TO_TIME (string, format)

  • Converts an epoch millisecond integer into a time value.

  • Converts a character string representation into a time value.

CAST

CAST (<expression> AS <data type>)

Converts an entity, or expression that evaluates to a single value, from one type to another.

Supported data types are:

  • BOOLEAN

  • INTEGER

  • INT

  • TIMESTAMP

  • DATE

  • CHAR

  • CHARACTER

  • STRING
Example of a SQL query using the listed functions:
SELECT TO_TIMESTAMP (100) AS timestamp_value,
  TO_DATE(r.event_timestamp) AS date_value,
  TO_TIME(r.event_timestamp) AS time_value
FROM raw_time_series AS r