ABS(%1) ABS(%1) ACOS(%1) ASIN(%1) ATAN(%1) ATAN2(%1,%2) CEILING(%1) CAST(CEIL(%1) AS BIGINT) CAST(CEIL(%1) AS BIGINT) COS(%1) (CASE WHEN %1 != 0 THEN {fn COT(%1)} ELSE NULL END) DAY(%1) DAY(%1) MONTH(%1) MONTH(%1) YEAR(%1) YEAR(%1) NOW() TODAY() DEGREES(%1) EXP(%1) FLOOR(%1) CAST(FLOOR(%1) AS BIGINT) CAST(FLOOR(%1) AS BIGINT) (((CASE WHEN (ABS((%2) - (CAST(((%2) / SQRT(3.0)) AS LONG) * SQRT(3.0)))) + SQRT(3.0) * ((ABS((%1) - (CAST(((%1) / 3.0) AS LONG) * 3.0))) - 1.0) > 0.0 THEN 1.5 ELSE 0.0 END) - (CASE WHEN ((%1) - (CAST( ( (%1) / 3.0 ) AS LONG) * 3.0) < 0.0) AND ((CASE WHEN (ABS((%2) - (CAST( ( (%2) / SQRT(3.0) ) AS LONG) * SQRT(3.0)))) + SQRT(3.0) * ((ABS((%1) - (CAST( ( (%1) / 3.0 ) AS LONG) * 3.0))) - 1.0) > 0.0 THEN 1.5 ELSE 0.0 END) > 0.0) THEN 3.0 ELSE 0.0 END)) + (CAST( ( (%1) / 3.0 ) AS LONG) * 3.0)) ROUND((((CASE WHEN (ABS((%2) - (ROUND(((%2) / SQRT(3.0)), 0) * SQRT(3.0)))) + SQRT(3.0) * ((ABS((%1) - (ROUND(((%1) / 3.0), 0) * 3.0))) - 1.0) > 0.0 THEN SQRT(3.0) / 2.0 ELSE 0.0 END) - (CASE WHEN ((%2) - (ROUND(((%2) / SQRT(3.0)), 0 ) * SQRT(3.0)) < 0.0) AND ((CASE WHEN (ABS((%2) - (ROUND(((%2) / SQRT(3.0)), 0) * SQRT(3.0)))) + SQRT(3.0) * ((ABS((%1) - (ROUND(((%1) / 3.0), 0 ) * 3.0))) - 1.0) > 0.0 THEN SQRT(3.0) / 2.0 ELSE 0.0 END) > 0.0) THEN SQRT(3.0) ELSE 0.0 END)) + (ROUND(((%2) / SQRT(3.0)), 0) * SQRT(3.0))), 3) (CASE WHEN %1 > 0 THEN {fn LOG(%1)} ELSE NULL END) (CASE WHEN %1 > 0 THEN {fn LOG10(%1)} ELSE NULL END) (CASE WHEN %1 > 0 THEN {fn LOG10(%1)} / {fn LOG10(2)} ELSE NULL END) %1 % %2 PI() (CASE WHEN %1 >= 0 OR FLOOR(%2) = %2 THEN POWER(%1,%2) END) POWER(%1,%2) POWER(CAST(%1 AS FLOAT),%2) RADIANS(%1) ROUND(%1,0) ROUND(%1,%2) ROUND(%1,%2) ROUND(%1,0) SIGN(%1) SIN(%1) (CASE WHEN %1 < 0 THEN NULL ELSE SQRT(%1) END) POWER(%1,2) POWER(%1, 2) TAN(%1) TRUNCATE(%1) COALESCE(%1, 0) IFNULL(%1, 0) AVG(%1) %1 AVG(%1) %1 COUNT(%1) (CASE WHEN %1 THEN 1 WHEN NOT %1 THEN 1 ELSE 0 END) COUNT(%1) (CASE WHEN (%1 IS NULL) THEN 0 ELSE 1 END) COUNT(%1) (CASE WHEN (%1 IS NULL) THEN 0 ELSE 1 END) COUNT(%1) (CASE WHEN %1 IS NULL THEN 0 ELSE 1 END) COUNT(DISTINCT %1) (CASE WHEN %1 THEN 1 WHEN NOT %1 THEN 1 ELSE 0 END) COUNT(DISTINCT %1) (CASE WHEN (%1 IS NULL) THEN 0 ELSE 1 END) COUNT(DISTINCT %1) (CASE WHEN %1 IS NULL THEN 0 ELSE 1 END) COUNT(DISTINCT %1) (CASE WHEN %1 IS NULL THEN 0 ELSE 1 END) COUNT(DISTINCT %1) (CASE WHEN %1 IS NULL THEN 0 ELSE 1 END) COUNT(DISTINCT %1) (CASE WHEN %1 IS NULL THEN 0 ELSE 1 END) MAX(%1) %1 MAX(%1) %1 MAX(%1) %1 MAX(%1) %1 MAX(%1) %1 MAX(%1) %1 MIN(%1) %1 (MIN(CASE WHEN %1 THEN 1 WHEN NOT %1 THEN 0 ELSE CAST(NULL AS INTEGER) END)=1) %1 MIN(%1) %1 MIN(%1) %1 MIN(%1) %1 MIN(%1) %1 (CASE WHEN (%1 IS NULL) OR (%2 IS NULL) THEN NULL WHEN %1 > %2 THEN %1 ELSE %2 END) (CASE WHEN (%1 IS NULL) OR (%2 IS NULL) THEN NULL WHEN %1 > %2 THEN %1 ELSE %2 END) (CASE WHEN (%1 IS NULL) OR (%2 IS NULL) THEN NULL WHEN %1 > %2 THEN %1 ELSE %2 END) (CASE WHEN (%1 IS NULL) OR (%2 IS NULL) THEN NULL WHEN %1 > %2 THEN %1 ELSE %2 END) (CASE WHEN (%1 IS NULL) OR (%2 IS NULL) THEN NULL WHEN %1 > %2 THEN %1 ELSE %2 END) (CASE WHEN (%1 IS NULL) OR (%2 IS NULL) THEN NULL WHEN %1 < %2 THEN %1 ELSE %2 END) (CASE WHEN (%1 IS NULL) OR (%2 IS NULL) THEN NULL WHEN %1 < %2 THEN %1 ELSE %2 END) (CASE WHEN (%1 IS NULL) OR (%2 IS NULL) THEN NULL WHEN %1 < %2 THEN %1 ELSE %2 END) (CASE WHEN (%1 IS NULL) OR (%2 IS NULL) THEN NULL WHEN %1 < %2 THEN %1 ELSE %2 END) (CASE WHEN (%1 IS NULL) OR (%2 IS NULL) THEN NULL WHEN %1 < %2 THEN %1 ELSE %2 END) STDDEV_SAMP(%1) NULL STDDEV_POP(%1) (CASE WHEN %1 IS NULL THEN CAST(NULL AS DOUBLE) ELSE 0.0 END) SUM(%1) %1 SUM(%1) %1 VAR_SAMP(%1) NULL VAR_POP(%1) (CASE WHEN %1 IS NULL THEN CAST(NULL AS DOUBLE) ELSE 0.0 END) (CASE WHEN (%1 IS NULL) THEN CAST(NULL AS DATE) ELSE DATE_TRUNC('day', CAST('1900-01-01' AS DATE) + FLOOR(%1) * INTERVAL 1 DAY) END) (CASE WHEN (%1 IS NULL) THEN CAST(NULL AS DATE) ELSE (CAST('1900-01-01' AS DATE) + %1 * INTERVAL 1 DAY) END) CAST(%1 AS DATE) CAST(%1 AS DATE) CAST(%1 AS DATE) CAST(%1 AS TIMESTAMP) CAST(%1 AS TIMESTAMP) CAST(%1 AS TIMESTAMP) CAST(%1 as TIMESTAMP) CAST(%1 AS TIMESTAMP) CAST(%1 AS FLOAT) CAST(%1 AS REAL) CAST(%1 AS DOUBLE) CAST(%1 AS REAL) CAST(DATE_DIFF('DAY', CAST('1900-01-01' AS DATE), %1) AS FLOAT) CAST(DATE_DIFF('DAY', CAST('1900-01-01' AS DATE), %1) AS FLOAT) CAST(%1 AS INTEGER) CAST(TRUNCATE(%1) AS BIGINT) CAST(%1 AS INTEGER) CAST(TRUNCATE(CAST(%1 AS REAL)) AS INTEGER) CAST(DATE_DIFF('DAY', CAST('1900-01-01' AS DATE), %1) AS INTEGER) CAST(DATE_DIFF('DAY', CAST('1900-01-01' AS DATE), %1) AS INTEGER) (CASE WHEN %1 = TRUE THEN '1' WHEN NOT %1 = TRUE THEN '0' ELSE CAST(NULL AS STRING) END) CAST(%1 AS STRING) CAST(%1 AS STRING) CAST(%1 AS STRING) CAST(%1 AS STRING) CAST(%1 AS STRING) ASCII(%1) CHAR(CAST(%1 AS INTEGER)) CHAR(%1) (LOCATE(%2,%1) > 0) RIGHT(%1, CHAR_LENGTH(%2)) = %2 CASE WHEN %2 < 0 THEN NULL ELSE LEFT(%1, %2) END CASE WHEN %2 < 0 THEN NULL ELSE LEFT(%1, %2) END CHAR_LENGTH(%1) LCASE(%1) LTRIM(%1) LTRIM(%1,%2) LOCATE(%2, %1) (CASE WHEN (%3 IS NULL) THEN NULL WHEN %3 < 1 THEN LOCATE(%2,%1,1) ELSE LOCATE(%2,%1,CONVERT(TRUNCATE(%3,0), SQL_BIGINT)) END) LOCATE(%2, %1, %3) (CASE WHEN (%2 IS NULL) OR %2 < 1 THEN NULL ELSE SUBSTRING(%1, CAST(FLOOR(%2) AS INTEGER), CHAR_LENGTH(%1) - (CAST(FLOOR(%2) AS INTEGER)) + 1) END) (CASE WHEN %2 IS NULL THEN NULL ELSE SUBSTRING(%1, %2, CHAR_LENGTH(%1)) END) (CASE WHEN %2 IS NULL OR %3 IS NULL THEN NULL WHEN CAST(FLOOR(%3) AS INTEGER) < 1 THEN '' WHEN CAST(FLOOR(%2) AS INTEGER) < 1 THEN SUBSTRING(%1, 1, CAST(FLOOR(%3) AS INTEGER)) ELSE SUBSTRING(%1, CAST(FLOOR(%2) AS INTEGER), CAST(FLOOR(%3) AS INTEGER)) END) (CASE WHEN (%2 IS NULL) OR (%3 IS NULL) THEN NULL WHEN %3 < 1 THEN '' WHEN %2 < 1 THEN SUBSTRING(%1,1,%3) ELSE SUBSTRING(%1,%2,%3) END) REPLACE(%1,%2,%3) RTRIM(%1) SPACE(CAST(%1 AS INTEGER)) SPACE(%1) (CASE WHEN %2 IS NULL THEN NULL WHEN %2 IS NOT NULL THEN (LOCATE(%2, %1) = 1) END) UCASE(%1) LTRIM(RTRIM(%1)) VAR_POP(%1) (CASE WHEN %1 IS NULL THEN NULL ELSE 0.0 END) (CASE WHEN %2 >= 0 THEN RIGHT(%1,%2) ELSE NULL END) CASE WHEN %2 >= 0 THEN {fn RIGHT(%1,%2)} ELSE NULL END (%1 IS NULL) (%1 IS NULL) (%1 IS NULL) (%1 IS NULL) (%1 IS NULL) IIF(%1 IS NULL, NULL, (IIF(%1, %2, %3))) IIF(%1 IS NULL, NULL, (IIF(%1, %2, %3))) (CASE WHEN %1 THEN %2 WHEN NOT %1 THEN %3 ELSE %4 END) IIF(%1 IS NULL, NULL, (IIF(%1, %2, %3))) (CASE WHEN %1 THEN %2 WHEN NOT %1 THEN %3 ELSE %4 END) IIF(%1 IS NULL, NULL, (IIF(%1, %2, %3))) (CASE WHEN %1 THEN %2 WHEN NOT %1 THEN %3 ELSE %4 END) IIF(%1 IS NULL, NULL, (IIF(%1, %2, %3))) (CASE WHEN %1 THEN %2 WHEN NOT %1 THEN %3 ELSE %4 END) IIF(%1 IS NULL, NULL, (IIF(%1, %2, %3))) (CASE WHEN %1 THEN %2 WHEN NOT %1 THEN %3 ELSE %4 END) IFNULL(%1, %2) IFNULL(%1, %2) IFNULL(%1, %2) IFNULL(%1, %2) IFNULL(%1, %2) IFNULL(%1, %2) (CAST(%1 AS DATE) IS NOT NULL) (CASE WHEN %1 IS NULL OR %2 IS NULL THEN NULL ELSE CONCAT(%1, %2) END) (CASE WHEN %2 IS NOT NULL THEN DATEADD( 's', CAST((%2 * 24 * 60 - CAST(%2 * 24 * 60 AS INTEGER)) * 60 AS INTEGER), CAST(DATEADD('mi', CAST((%2 * 24 - CAST(%2 * 24 AS INTEGER)) * 60 AS INTEGER), CAST(DATEADD('hh', CAST((%2 - CAST(%2 AS INTEGER)) * 24 AS INTEGER), CAST(DATEADD('d', CAST(%2 AS INTEGER), CAST(%1 AS TIMESTAMP)) AS TIMESTAMP)) AS TIMESTAMP)) AS TIMESTAMP)) END) (CAST(%1 AS TIMESTAMP) + %2 * INTERVAL '1' DAY) (%1 + %2) (CASE WHEN %2 IS NOT NULL THEN DATEADD( 's', CAST((%2 * 24 * 60 - CAST(%2 * 24 * 60 AS INTEGER)) * 60 AS INTEGER), CAST(DATEADD('mi', CAST((%2 * 24 - CAST(%2 * 24 AS INTEGER)) * 60 AS INTEGER), CAST(DATEADD('hh', CAST((%2 - CAST(%2 AS INTEGER)) * 24 AS INTEGER), CAST(DATEADD('d', CAST(%2 AS INTEGER), CAST(%1 AS TIMESTAMP)) AS TIMESTAMP)) AS TIMESTAMP)) AS TIMESTAMP)) END) DATEADD('day', CAST(TRUNCATE(%2) AS INTEGER), %1) (%1 + %2 * INTERVAL '1' DAY) (%1 + %2) (CASE WHEN %2 = 0 THEN NULL ELSE MOD(%1,%2)) (CASE WHEN %2 = 0 THEN NULL ELSE MOD(%1,%2) END) (DATEDIFF('d',%2,%1)) (DATE_DIFF('DAY', CAST(%2 AS TIMESTAMP), CAST(%1 AS TIMESTAMP)) + (COALESCE(HOUR(%1), 0) - COALESCE(HOUR(%2), 0) + (COALESCE(MINUTE(%1), 0) - COALESCE(MINUTE(%2), 0) + (COALESCE(SECOND(%1), 0) - COALESCE(SECOND(%2), 0)) / 60.0) / 60.0) / 24.0) CASE WHEN %1 IS NULL OR %2 IS NULL THEN CAST(NULL AS DOUBLE) ELSE ((CAST(CAST(%1 AS DATE) AS LONG) - CAST(%2 AS LONG)) / 86400000.0 + CAST(EXTRACT(HOUR FROM %1) AS DOUBLE) / 24 + CAST(EXTRACT(MINUTE FROM %1) AS DOUBLE) / (24 * 60) + CAST(EXTRACT(SECOND FROM %1) AS DOUBLE) / (24 * 60 * 60) ) END (CAST(%1 AS LONG) - CAST(%2 AS LONG)) / 86400000.0 (CAST(%1 AS LONG) - CAST(%2 AS LONG)) / 86400000.0 (%1 - (CAST(%2 AS INTEGER) * INTERVAL 1 DAY) - (CAST((%2 - CAST(%2 AS INTEGER)) * 24 AS INTEGER) * INTERVAL 1 HOUR) - (CAST((%2 * 24 - CAST(%2 * 24 AS INTEGER)) * 60 AS INTEGER) * INTERVAL 1 MINUTE) - (CAST((%2 * 24 * 60 - CAST(%2 * 24 * 60 AS INTEGER)) * 60 AS INTEGER) * INTERVAL 1 SECOND)) (CAST(%1 AS TIMESTAMP) - %2 * INTERVAL '1' DAY) DATEADD('second',CAST((%2 * 24 * 60 - CAST(%2 * 24 * 60 AS INTEGER)) * -60 AS INTEGER),DATEADD('minute',CAST((%2 * 24 - CAST(%2 * 24 AS INTEGER)) * -60 AS INTEGER),DATEADD('hour',CAST((%2 - CAST(%2 AS INTEGER)) * -24 AS INTEGER),DATEADD('day',CAST(-%2 AS INTEGER),CAST(%1 AS TIMESTAMP))))) DATEADD('day', CAST(TRUNCATE(-1 * %2) AS INTEGER), %1) DATEADD('day', -1 * %2, %1) (CASE WHEN %2 <> 0 THEN %1 / %2 END) (CASE WHEN %2 = 0 THEN NULL ELSE %1 / %2 END) (CASE WHEN %2 = 0 THEN NULL ELSE %1 / %2 END) (CASE WHEN %2 = 0 THEN CAST(NULL AS DOUBLE) ELSE CAST(%1 AS DOUBLE) / %2 END) (CASE WHEN %1 < 0 AND TRUNCATE(%2) <> %2 THEN NULL ELSE POWER(%1,%2) END) (CASE WHEN %1 < 0 AND FLOOR(%2) <> %2 THEN NULL ELSE POWER(%1,%2) END) POWER(CAST(%1 AS FLOAT),%2) LTRIM(CAST(YEAR(%2) AS VARCHAR)) LTRIM(CAST(QUARTER(%2) AS VARCHAR)) MONTHNAME(%2) LTRIM(CAST(DAYOFYEAR(%2) AS VARCHAR)) LTRIM(CAST(DAYOFMONTH(%2) AS VARCHAR)) DAYNAME(%2) LTRIM(CAST(WEEK(%2) AS VARCHAR)) LTRIM(CAST(HOUR(CAST(%2 AS TIMESTAMP)) AS VARCHAR)) LTRIM(CAST(MINUTE(CAST(%2 AS TIMESTAMP)) AS VARCHAR)) LTRIM(CAST(SECOND(CAST(%2 AS TIMESTAMP)) AS VARCHAR)) LTRIM(CAST(YEAR(%2) AS VARCHAR)) LTRIM(CAST(QUARTER(%2) AS VARCHAR)) MONTHNAME(%2) LTRIM(CAST(DAYOFYEAR(%2) AS VARCHAR)) LTRIM(CAST(DAYOFMONTH(%2) AS VARCHAR)) DAYNAME(%2) LTRIM(CAST(WEEK(%2) AS VARCHAR)) LTRIM(CAST(HOUR(CAST(%2 AS TIMESTAMP)) AS VARCHAR)) LTRIM(CAST(MINUTE(CAST(%2 AS TIMESTAMP)) AS VARCHAR)) LTRIM(CAST(SECOND(CAST(%2 AS TIMESTAMP)) AS VARCHAR)) LTRIM(CAST(YEAR(%2) AS VARCHAR)) LTRIM(CAST(QUARTER(%2) AS VARCHAR)) MONTHNAME(%2) LTRIM(CAST(DAYOFYEAR(%2) AS VARCHAR)) LTRIM(CAST(DAYOFMONTH(%2) AS VARCHAR)) DAYNAME(%2) RTRIM(CAST(CAST(FLOOR((7 + DAYOFYEAR(%2) - 1 + ISODOW(CAST(CONCAT(RIGHT(CAST(CAST(ABS(YEAR(%2)) AS LONG) AS STRING),4), '-01-01') AS DATE)) - 1) / 7) AS LONG) AS STRING)) LTRIM(CAST(HOUR(CAST(%2 AS TIMESTAMP)) AS VARCHAR)) LTRIM(CAST(MINUTE(CAST(%2 AS TIMESTAMP)) AS VARCHAR)) LTRIM(CAST(SECOND(CAST(%2 AS TIMESTAMP)) AS VARCHAR)) LTRIM(CAST(YEAR(%2) AS VARCHAR)) LTRIM(CAST(QUARTER(%2) AS VARCHAR)) MONTHNAME(%2) LTRIM(CAST(DAYOFYEAR(%2) AS VARCHAR)) LTRIM(CAST(DAYOFMONTH(%2) AS VARCHAR)) DAYNAME(%2) RTRIM(CAST(CAST(FLOOR((7 + DAYOFYEAR(%2) - 1 + ISODOW(CAST(CONCAT(RIGHT(CAST(CAST(ABS(YEAR(%2)) AS LONG) AS STRING),4), '-01-01') AS DATE)) - 1) / 7) AS LONG) AS STRING)) LTRIM(CAST(HOUR(CAST(%2 AS TIMESTAMP)) AS VARCHAR)) LTRIM(CAST(MINUTE(CAST(%2 AS TIMESTAMP)) AS VARCHAR)) LTRIM(CAST(SECOND(CAST(%2 AS TIMESTAMP)) AS VARCHAR)) DATE_PART('%1',%2) DATE_PART('year',%2) DATE_PART('quarter',%2) DATE_PART('month',%2) DATE_PART('dayofyear',%2) DATE_PART('day',%2) DATE_PART('weekday',%2) DATE_PART('week',%2) DATE_PART('hour',%2) DATE_PART('minute',%2) DATE_PART('second',%2) DATE_PART('%1',%2) DATE_PART('year',%2) DATE_PART('quarter',%2) DATE_PART('month',%2) DATE_PART('dayofyear',%2) DATE_PART('day',%2) DATE_PART('weekday',%2) DATE_PART('week',%2) DATE_PART('hour',%2) DATE_PART('minute',%2) DATE_PART('second',%2) DATE_PART('%1',%2) DATE_PART('year',%2) DATE_PART('quarter',%2) DATE_PART('month',%2) DATE_PART('dayofyear',%2) DATE_PART('day',%2) DATE_PART('weekday',%2) FLOOR((7 + DAY_OF_YEAR(%2) - 1 + ((((CAST(DATE_TRUNC('year', CAST(%2 AS DATE)) AS LONG) / 86400000) + 2440587.5 + 1) % 7))) / 7) DATE_PART('hour',%2) DATE_PART('minute',%2) DATE_PART('second',%2) DATE_PART('%1',%2) DATE_PART('year',%2) DATE_PART('quarter',%2) DATE_PART('month',%2) DATE_PART('dayofyear',%2) DATE_PART('day',%2) DATE_PART('weekday',%2) FLOOR((7 + DAY_OF_YEAR(%2) - 1 + ((((CAST(DATE_TRUNC('year', CAST(%2 AS DATE)) AS LONG) / 86400000) + 2440587.5 + 1) % 7))) / 7) DATE_PART('hour',%2) DATE_PART('minute',%2) DATE_PART('second',%2) DATE_TRUNC('%1',%2) DATE_TRUNC('year',%2) DATE_TRUNC('quarter',%2) DATE_TRUNC('month',%2) DATE_TRUNC('day',%2) DATE_TRUNC('day',%2) DATE_TRUNC('day',%2) CAST(%2 AS DATE) + (-1 * (( 7 + DAYOFWEEK( CAST(%2 AS DATE) ) - 1 ) % 7)) * INTERVAL 1 DAY DATE_TRUNC('hour',%2) DATE_TRUNC('minute',%2) DATE_TRUNC('second',%2) CAST(DATE_TRUNC('%1',%2) AS TIMESTAMP) CAST(DATE_TRUNC('year',%2) AS TIMESTAMP) CAST(DATE_TRUNC('quarter',%2) AS TIMESTAMP) CAST(DATE_TRUNC('month',%2) AS TIMESTAMP) CAST(DATE_TRUNC('day',%2) AS TIMESTAMP) CAST(DATE_TRUNC('day',%2) AS TIMESTAMP) CAST(DATE_TRUNC('day',%2) AS TIMESTAMP) CAST(%2 AS DATE) + (-1 * (( 7 + DAYOFWEEK( CAST(%2 AS DATE) ) - 1 ) % 7)) * INTERVAL 1 DAY CAST(DATE_TRUNC('hour',%2) AS TIMESTAMP) CAST(DATE_TRUNC('minute',%2) AS TIMESTAMP) CAST(DATE_TRUNC('second',%2) AS TIMESTAMP) DATE_TRUNC('%1',%2) DATE_TRUNC('year',%2) DATE_TRUNC('quarter',%2) DATE_TRUNC('month',%2) DATE_TRUNC('day',%2) DATE_TRUNC('day',%2) (DATE_TRUNC('day', CAST(%2 AS DATE)) - (7 + (((CAST(DATE_TRUNC('year', CAST(%2 AS DATE)) AS LONG) / 86400000) + 2440587.5 + 1) % 7) - %3) % 7) CAST(%2 AS DATE) + (-1 * (( 7 + DAYOFWEEK( CAST(%2 AS DATE) ) - 2 ) % 7)) * INTERVAL 1 DAY DATE_TRUNC('hour',%2) DATE_TRUNC('minute',%2) DATE_TRUNC('second',%2) CAST(DATE_TRUNC('%1',%2) AS TIMESTAMP) CAST(DATE_TRUNC('year',%2) AS TIMESTAMP) CAST(DATE_TRUNC('quarter',%2) AS TIMESTAMP) CAST(DATE_TRUNC('month',%2) AS TIMESTAMP) CAST(DATE_TRUNC('day',%2) AS TIMESTAMP) CAST(DATE_TRUNC('day',%2) AS TIMESTAMP) CAST(DATE_TRUNC('day',%2) AS TIMESTAMP) CAST(%2 AS DATE) + (-1 * (( 7 + DAYOFWEEK( CAST(%2 AS DATE) ) - 2 ) % 7)) * INTERVAL 1 DAY CAST(DATE_TRUNC('hour',%2) AS TIMESTAMP) CAST(DATE_TRUNC('minute',%2) AS TIMESTAMP) CAST(DATE_TRUNC('second',%2) AS TIMESTAMP) DATEADD(%1,%2,%3) DATEADD('yy',%2,%3) DATEADD('q',%2,%3) DATEADD('m',%2,%3) DATEADD('dy',%2,%3) DATEADD('d',%2,%3) DATEADD('dw',%2,%3) DATEADD('ww',%2,%3) DATEADD('hh',%2,%3) DATEADD('mi',%2,%3) DATEADD('ss',%2,%3) DATEADD(%1,%2,%3) DATEADD('yy',%2,%3) DATEADD('q',%2,%3) DATEADD('m',%2,%3) DATEADD('dy',%2,%3) DATEADD('d',%2,%3) DATEADD('dw',%2,%3) DATEADD('ww',%2,%3) DATEADD('hh',%2,%3) DATEADD('mi',%2,%3) DATEADD('ss',%2,%3) DATEDIFF(%1,%2,%3) DATEDIFF('yy',%2,%3) DATEDIFF('q',%2,%3) DATEDIFF('m',%2,%3) DATEDIFF('dy',%2,%3) DATEDIFF('d',%2,%3) DATEDIFF('dw',%2,%3) DATEDIFF('ww',%2,%3) DATEDIFF('hh',%2,%3) DATEDIFF('mi',%2,%3) DATEDIFF('ss',%2,%3) DATEDIFF(%1,%2,%3) DATEDIFF('yy',%2,%3) DATEDIFF('q',%2,%3) DATEDIFF('m',%2,%3) DATEDIFF('dy',%2,%3) DATEDIFF('d',%2,%3) DATEDIFF('dw',%2,%3) DATEDIFF('ww',%2,%3) DATEDIFF('hh',%2,%3) DATEDIFF('mi',%2,%3) DATEDIFF('ss',%2,%3) DATEDIFF(%1,%2,%3) DATEDIFF('yy',%2,%3) DATEDIFF('q',%2,%3) DATEDIFF('m',%2,%3) DATEDIFF('dy',%2,%3) DATEDIFF('d',%2,%3) DATEDIFF('dw',%2,%3) DATEDIFF('ww',%2,%3) DATEDIFF('hh',%2,%3) DATEDIFF('mi',%2,%3) DATEDIFF('ss',%2,%3) DATEDIFF(%1,%2,%3) DATEDIFF('yy',%2,%3) DATEDIFF('q',%2,%3) DATEDIFF('m',%2,%3) DATEDIFF('dy',%2,%3) DATEDIFF('d',%2,%3) DATEDIFF('dw',%2,%3) DATEDIFF('ww',%2,%3) DATEDIFF('hh',%2,%3) DATEDIFF('mi',%2,%3) DATEDIFF('ss',%2,%3) DATEDIFF(%1,%2,%3) DATEDIFF('yy',%2,%3) DATEDIFF('q',%2,%3) DATEDIFF('m',%2,%3) DATEDIFF('dy',%2,%3) DATEDIFF('d',%2,%3) DATEDIFF('dw',%2,%3) IIF(%4 = 1, CAST(((FLOOR(CAST(%3 AS LONG) / 86400000) - EXTRACT(ISODOW FROM %3)) - (FLOOR(CAST(%2 AS LONG) / 86400000) - EXTRACT(ISODOW FROM %2))) / 7 AS LONG), DATEDIFF('ww',%2,%3)) DATEDIFF('hh',%2,%3) DATEDIFF('mi',%2,%3) DATEDIFF('ss',%2,%3) DATEDIFF(%1,%2,%3) DATEDIFF('yy',%2,%3) DATEDIFF('q',%2,%3) DATEDIFF('m',%2,%3) DATEDIFF('dy',%2,%3) DATEDIFF('d',%2,%3) DATEDIFF('dw',%2,%3) IIF(%4 = 1, CAST(((FLOOR(CAST(%3 AS LONG) / 86400000) - EXTRACT(ISODOW FROM %3)) - (FLOOR(CAST(%2 AS LONG) / 86400000) - EXTRACT(ISODOW FROM %2))) / 7 AS LONG), DATEDIFF('ww',%2,%3)) DATEDIFF('hh',%2,%3) DATEDIFF('mi',%2,%3) DATEDIFF('ss',%2,%3) DATEDIFF(%1,%2,%3) DATEDIFF('yy',%2,%3) DATEDIFF('q',%2,%3) DATEDIFF('m',%2,%3) DATEDIFF('dy',%2,%3) DATEDIFF('d',%2,%3) DATEDIFF('dw',%2,%3) IIF(%4 = 1, CAST(((FLOOR(CAST(%3 AS LONG) / 86400000) - EXTRACT(ISODOW FROM %3)) - (FLOOR(CAST(%2 AS LONG) / 86400000) - EXTRACT(ISODOW FROM %2))) / 7 AS LONG), DATEDIFF('ww',%2,%3)) DATEDIFF('hh',%2,%3) DATEDIFF('mi',%2,%3) DATEDIFF('ss',%2,%3) DATEDIFF(%1,%2,%3) DATEDIFF('yy',%2,%3) DATEDIFF('q',%2,%3) DATEDIFF('m',%2,%3) DATEDIFF('dy',%2,%3) DATEDIFF('d',%2,%3) DATEDIFF('dw',%2,%3) IIF(%4 = 1, CAST(((FLOOR(CAST(%3 AS LONG) / 86400000) - EXTRACT(ISODOW FROM %3)) - (FLOOR(CAST(%2 AS LONG) / 86400000) - EXTRACT(ISODOW FROM %2))) / 7 AS LONG), DATEDIFF('ww',%2,%3)) DATEDIFF('hh',%2,%3) DATEDIFF('mi',%2,%3) DATEDIFF('ss',%2,%3)