Page History

This document details Aqua Data Studio's Excel SQL syntax and functions. Supported functions include Aggregate Functions, Numeric Functions, String Functions, Time and Date Functions.

Numeric Functions New in 17.0

String Functions New in 17.0

Time and Date Functions New in 17.0

More Functions New in 17.0

Aggregate Functions (New in 17.0)

...

SELECT VAR_SAMP(ID) FROM Employee

Back to top

Numeric Functions (New in 17.0)

ABS

Returns the absolute value of the numeric expression.

...

SELECT ZERO() FROM Employee

Back to top

String Functions (New in 17.0)

ASCII

Returns the ASCII value of the first character in the string. This method returns an int.

...

SELECT DIFFERENCE(Fname, City) FROM Employee

Back to top

LOWER

Converts a string to lowercase.
 

Example

SELECT LOWER(Fname) FROM Employee

...

SELECT XMLTEXT('Text data') FROM Employee 

Back to top

Time and Date Functions (New in 17.0)

CURRENT_DATE

Returns the current date.

...

SELECT DAYNAME('2001-01-31') FROM Employee

Back to top

DAY_OF_MONTH

Returns the day of month (1-31).
 

Example

SELECT DAY_OF_MONTH('2001-01-31') FROM Employee 

...

SELECT YEAR('2045-02-03') FROM Employee

Back to top

More Functions (New in 17.0)

CAST

Converts a value to another data type.

...