Conversion Functions

Conversion functions convert values from one data type to another.

The following table lists the supported functions:

Function Syntax Description
epoch() epoch(timestamp expr t) Returns the number of seconds since the epoch given a timestamp value
int() int(double expr x) Returns an int from a double
long() long(double expr x) Returns a long from a double
parseDate() parseDate(string expr s_date, string mask) Returns date from a string using a specified format
parseDouble() parseDouble(string expr x, string mask) Returns double from a string
parseTimestamp() parseTimestamp(string expr date, string mask) Return a timestamp from a string with a given time and date format
quarter() quarter([timestamp or date] expr t) Returns the quarter corresponding to a timestamp or date expression
second() second([timestamp or date] expr t) Returns the seconds component of a timestamp or date expression
string() string(int expr n) Returns a string from an int
timestamp() timestamp(string expr t) Returns a timestamp from a string
double() double(string expr str) Returns a double from string str
toChar() toChar(date expr d, string fmt) Returns a string from date d formatted with fmt

© Incorta, Inc. All Rights Reserved.