CData Power BI Connector for AWS Data Management 2019 - Online Help
Questions / Feedback?

SQL Functions

CData Power BI Connector for AWS Data Management 2019 - Build 19.0.7362

The connector provides functions that are similar to those that are available with most standard databases. These functions are implemented in the CData provider engine and thus are available across all data sources with the same consistent API. Three categories of functions are available: string, date, and math.

The connector interprets all SQL function inputs as either strings or column identifiers, so you need to escape all literals as strings, with single quotes. For example, contrast the SQL Server syntax and connector syntax for the DATENAME function:

  • SQL Server:
    SELECT DATENAME(yy,GETDATE())
  • connector:
    SELECT DATENAME('yy',GETDATE())

String Functions

These functions perform string manipulations and return a string value. See STRING Functions for more details.

SELECT CONCAT(firstname, space(4), lastname) FROM NorthwindProducts WHERE Industry = 'Floppy Disks'

Date Functions

These functions perform date and date time manipulations. See DATE Functions for more details.

SELECT CURRENT_TIMESTAMP() FROM NorthwindProducts

Math Functions

These functions provide mathematical operations. See MATH Functions for more details.

SELECT RAND() FROM NorthwindProducts

Function Parameters and Nesting SQL Functions

The connector supports column names, constants, and results of other functions as parameters to functions. The following are all valid uses of SQL functions:
SELECT CONCAT('Mr.', SPACE(2), firstname, SPACE(4), lastname) FROM NorthwindProducts

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7362.0