Built-in Functions → Conversion Functions

The conversion functions convert values from one data type to another. Here are the supported functons:

Functions for returning an Integer

FunctionSignatureDescription
int()int(double exp)Returns an int from a double
quarter()quarter()Returns an int corresponding to the quarter number of the current quarter
quarter()quarter(date_timestamp exp)Returns an int corresponding to the quarter number of the given date or timestamp
quarterDay()quarterDay()Returns an int corresponding to the count of days from the beginning of the quarter till the current date
quarterDay()quarterDay(date_timestamp exp)Returns an int to the count of days from the beginning of the quarter till a given date or timestamp
quarterMonth()quarterMonth()Returns an int corresponding to the month number of the quarter from the beginning of the quarter for the current date
quarterMonth()quarterMonth(date_timestamp exp)Returns an int corresponding to the month number of the quarter from the beginning of the quarter for a given date or timestamp
quarterWeek()quarterWeek()Returns an int corresponding to the week number of the quarter from the beginning of the quarter for the current date
quarterWeek()quarterWeek(date_timestamp exp)Returns an int corresponding to the week number of the quarter from the beginning of the quarter for a given date or timestamp
month()month()Returns an int corresponding to the month value of the current month
monthWeek()monthWeek()Returns an int corresponding to the week number of the current month
monthWeek()monthWeek(date_timestamp exp)Returns an int corresponding to the week number of the month for a given date or timestamp
weekDay()weekDay()Returns an int corresponding to the count of days from the beginning of the week till the current date
weeknum()weeknum()Returns an int corresponding to the week number of the current week for the current year
minute()minute()Returns an int corresponding to the minute value of the current time
hour()hour()Returns an int corresponding to the hour value of the current time
day()day()Returns an int corresponding to the day value of the current date
dayOfYear()dayOfYear(date_timestamp exp)Returns an int corresponding to the day number of the year for a given date or timestamp
year()year() Returns an int corresponding to the current year

Functions for returning a Double

FunctionSyntaxDescription
double()double(string exp)Returns a double from string
parseDouble()parseDouble(string exp, string mask)Returns double from a string
monthsBetween()monthsBetween(date_timestamp startDate, date_timestamp endDate)Returns a double corresponding to the number of months between two dates or timestamps

Functions for returning a Long

FunctionSyntaxDescription
long()long(double exp)Returns a long from a double
second()second()Returns the seconds component of the current time
second()second(timestamp or date)Returns the seconds component of a timestamp or date expression
epoch()epoch(date_timestamp exp)Returns the number of seconds since the epoch given a timestamp value

Functions for returning a String

FunctionSyntaxDescription
string()string(int exp)Returns a string from an int
toChar()toChar(date exp, string format)Returns a string from a date expression formatted with a string format
monthName()monthName(date_timestamp exp)Returns a string corresponding to the month name of a given date or timestamp.
monthName()monthName()Returns a string corresponding to the current month name.

Functions for returning a Date or Timestamp

FunctionSyntaxDescription
parseDate()parseDate(string exp, string mask)Returns date from a string using a specified format
parseTimestamp()parseTimestamp(string exp, string mask)Return a timestamp from a string with a given time and date format
timestamp()timestamp(string exp)Returns a timestamp from a string
quarterStartDate()quarterStartDate(date_timestamp exp)Returns a date corresponding to the first day of the quarter for a given date or timestamp
quarterEndDate()quarterEndDate(date_timestamp exp)Returns a date corresponding to the last day of the quarter for a given date or timestamp
monthStartDate()quarterStartDate(date_timestamp exp)Returns a date corresponding to the first day of the month for a given date or timestamp
monthEndDate()monthEndDate(date_timestamp exp)Returns a date corresponding to the last day of the month for a given date or timestamp
weekStartDate()weekStartDate(date_timestamp exp)Returns a date corresponding to the first day of the week for a given date or timestamp
weekEndDate()weekEndDate(date_timestamp exp)Returns a date corresponding to the last day of the week for a given date or timestamp