yes " " ' ' CAST('{0:yyyy-MM-dd HH':'mm':'ss}' AS timestamp) CAST("{0}" AS timestamp) Teradata YYYY-MM-DD HH:MM:SS YYYY-MM-DD HH:MM:SS 1 17 21 POSIX 30 30 2100 2100 0 0 System.Data.OleDb Microsoft.DataWarehouse.Design.OleDbSchema, Microsoft.DataWarehouse Microsoft.DataWarehouse.Controls.OleDbQueryDesigner, Microsoft.DataWarehouse System.Data.Odbc Microsoft.DataWarehouse.Design.OdbcSchema, Microsoft.DataWarehouse ABS ACOS ACOT ASIN ATAN CEILING COS COSH COT CURRENCY DEGREES DIVIDE EXP INT ISO.CEILING LN LOG LOG10 MAX MIN MOD MROUND POWER QUOTIENT RADIANS ROUND ROUNDDOWN ROUNDUP SIGN SIN SINH SQRT SQRTPI TAN TRUNC CONTAINSROW ISBLANK IF DATE DAY EDATE EOMONTH HOUR MINUTE MONTH SECOND TIME WEEKDAY WEEKNUM YEAR COMBINEVALUES CONCATENATE DATEVALUE FIND LEFT LEN LOWER MID REPT RIGHT SEARCH SUBSTITUTE TIMEVALUE TRIM UNICHAR UNICODE UPPER VALUE KEEPFILTERS RELATED USERELATIONSHIP SUM MINA MAXA AVERAGE AVERAGEA STDEV.S STDEV.P VAR.S VAR.P COUNT COUNTA COUNTROWS DISTINCTCOUNT auto yes STR STR R8 R8 R8 R8 R8 I8 I8 I8 I8 R8 DATE DATE long varchar timestamp yes nosubsel no ( ) ( ) ( SAMPLE ) TOP PERCENT WITH TIES ( SELECT ) UPDATE INSERT INTO VALUES () DELETE FROM DROP CREATE ( ) DISTINCT AS ( on ) left outer join right outer join full outer join inner join cross join FROM GROUP BY ORDER BY WHERE HAVING = ( ) VALUES ( ) SET DATABASE TABLE VIEW INDEX primary key ( ) COALESCE(, CAST( AS timestamp)) COALESCE(, 0) , (CASE WHEN IS NULL THEN 0 ELSE 1 END) ASC DESC @ ? * MIN MAX SUM ( ) cast(COUNT ( ) as bigint) = <> > >= < <= IN AND OR + - / * ( ) IS NULL ( ) varchar varchar varchar byteint tinyint smallint int bigint tinyint smallint int bigint real float timestamp timestamp DECIMAL(19, 4) sql_variant varchar varbyte decimal ( ) ( , ) CAST( AS BYTEINT) TIMESTAMP DATE TIMESTAMP CAST( AS DECIMAL(19, 4)) null LOWER() UPPER() LEN() TRIM(LEADING FROM ) TRIM(TRAILING FROM ) TRIM(BOTH FROM ) LOWER() UPPER() CHARACTER_LENGTH() TRIM(BOTH FROM ) CAST( AS FLOAT) CAST( AS DATE) CAST('1899-12-30 ' || TO_CHAR(CAST( AS TIME)) AS TIMESTAMP) CHR() ASCII() NOT() (NOT ) (CASE WHEN () THEN 0 ELSE 1 END) (1 - ) COALESCE(1 - , 1) (-) ABS CEILING FLOOR SIGN SQRT () POWER( , 2) EXP LN LOG () (COALESCE((), 0)) CAST(COUNT( ) AS BIGINT) (CAST(COUNT(DISTINCT ) AS BIGINT) + MAX(CASE WHEN IS NULL THEN 1 ELSE 0 END)) CAST(COUNT(DISTINCT ) AS BIGINT) ABS() SQRT() SIGN() FLOOR() () IN OR ( ) > < <> = >= <= COALESCE(, '') COALESCE(, DATE) COALESCE(, TIMESTAMP) COALESCE(, 0) COALESCE(, '') COALESCE(, DATE) COALESCE(, TIMESTAMP) COALESCE(, 0) ( ) ( = ) ( = ) ( = OR IS NULL AND IS NULL) ( = OR IS NULL AND IS NULL) ( IS NULL) ( IS NULL) ((CASE WHEN = OR IS NULL AND IS NULL THEN 1 ELSE 0 END) = 1) '' CAST( AS TIMESTAMP) 0 '' CAST( AS TIMESTAMP) 0 ( > ) ((CASE WHEN IS NULL THEN CASE WHEN >= THEN 1 ELSE 0 END ELSE CASE WHEN > THEN 1 ELSE 0 END END) = 1) ((CASE WHEN IS NULL THEN CASE WHEN < THEN 1 ELSE 0 END ELSE CASE WHEN > THEN 1 ELSE 0 END END) = 1) ((CASE WHEN IS NULL THEN CASE WHEN < THEN 1 ELSE 0 END ELSE CASE WHEN IS NULL THEN CASE WHEN >= THEN 1 ELSE 0 END ELSE CASE WHEN > THEN 1 ELSE 0 END END END) = 1) '' CAST( AS TIMESTAMP) 0 '' CAST( AS TIMESTAMP) 0 ( < ) ((CASE WHEN IS NULL THEN CASE WHEN < THEN 1 ELSE 0 END ELSE CASE WHEN < THEN 1 ELSE 0 END END) = 1) ((CASE WHEN IS NULL THEN CASE WHEN >= THEN 1 ELSE 0 END ELSE CASE WHEN < THEN 1 ELSE 0 END END) = 1) ((CASE WHEN IS NULL THEN CASE WHEN < THEN 1 ELSE 0 END ELSE CASE WHEN IS NULL THEN CASE WHEN >= THEN 1 ELSE 0 END ELSE CASE WHEN < THEN 1 ELSE 0 END END END) = 1) '' CAST( AS TIMESTAMP) 0 '' CAST( AS TIMESTAMP) 0 ( <= ) ((CASE WHEN () IS NULL THEN CASE WHEN >= THEN 1 ELSE 0 END ELSE CASE WHEN > THEN 1 ELSE 0 END END) = 0) ((CASE WHEN IS NULL THEN CASE WHEN < THEN 1 ELSE 0 END ELSE CASE WHEN > THEN 1 ELSE 0 END END) = 0) ((CASE WHEN IS NULL THEN CASE WHEN < THEN 1 ELSE 0 END ELSE CASE WHEN IS NULL THEN CASE WHEN >= THEN 1 ELSE 0 END ELSE CASE WHEN > THEN 1 ELSE 0 END END END) = 0) '' CAST( AS TIMESTAMP) 0 '' CAST( AS TIMESTAMP) 0 ( >= ) ((CASE WHEN () IS NULL THEN CASE WHEN < THEN 1 ELSE 0 END ELSE CASE WHEN < THEN 1 ELSE 0 END END) = 0) ((CASE WHEN IS NULL THEN CASE WHEN >= THEN 1 ELSE 0 END ELSE CASE WHEN < THEN 1 ELSE 0 END END) = 0) ((CASE WHEN IS NULL THEN CASE WHEN < THEN 1 ELSE 0 END ELSE CASE WHEN IS NULL THEN CASE WHEN >= THEN 1 ELSE 0 END ELSE CASE WHEN < THEN 1 ELSE 0 END END END) = 0) '' CAST( AS TIMESTAMP) 0 '' CAST( AS TIMESTAMP) 0 ( <> ) ((CASE WHEN IS NULL THEN 0 ELSE CASE WHEN = THEN 1 ELSE 0 END END) = 0) ((CASE WHEN IS NULL THEN 0 ELSE CASE WHEN = THEN 1 ELSE 0 END END) = 0) ( IS NOT NULL) ( IS NOT NULL) ((CASE WHEN = OR IS NULL AND IS NULL THEN 1 ELSE 0 END) = 0) '' CAST( AS TIMESTAMP) 0 '' CAST( AS TIMESTAMP) 0 ( = ) ((CASE WHEN IS NULL THEN 0 ELSE CASE WHEN = THEN 1 ELSE 0 END END) = 1) ((CASE WHEN IS NULL THEN 0 ELSE CASE WHEN = THEN 1 ELSE 0 END END) = 1) ( IS NULL) ( IS NULL) ((CASE WHEN = OR IS NULL AND IS NULL THEN 1 ELSE 0 END) = 1) ( * 86400 * INTERVAL DAY TO SECOND) ( * 86400 * INTERVAL DAY TO SECOND) ( + * 86400 * INTERVAL DAY TO SECOND) ( + ) COALESCE( + * 86400 * INTERVAL DAY TO SECOND, ) COALESCE( + , ) COALESCE( + , ) COALESCE( + * 86400 * INTERVAL DAY TO SECOND, ) COALESCE( + , ) COALESCE( + , ) COALESCE( + * 86400 * INTERVAL DAY TO SECOND, , ) COALESCE( + , , ) COALESCE( + , , ) COALESCE( + , , ) ( * 86400 * INTERVAL DAY TO SECOND) ( - * 86400 * INTERVAL DAY TO SECOND) ( - ) COALESCE( - * 86400 * INTERVAL DAY TO SECOND, ) COALESCE( - , ) COALESCE( - * 86400 * INTERVAL DAY TO SECOND , CAST( AS TIMESTAMP) - * 86400 * INTERVAL DAY TO SECOND) COALESCE( - , CAST( AS TIMESTAMP) - ) COALESCE( - * 86400 * INTERVAL DAY TO SECOND, , CAST( AS TIMESTAMP) - * 86400 * INTERVAL DAY TO SECOND) COALESCE( - , , CAST( AS TIMESTAMP) - ) COALESCE( - , , -) ( / ) ( / COALESCE(, 0)) ( * ) CAST( * AS DECIMAL(19, 4)) ( * ) (CASE WHEN IS NULL THEN NULL ELSE CASE WHEN IS NULL OR = 0 THEN ELSE / END END) OR AND ( ) COALESCE(, 0) POWER(, ) CAST(( / ) AS INTEGER) ROUND(, ) TRUNC(, ) CEIL(ABS() * POWER(10.0, )) * SIGN() / POWER(10.0, ) (CASE WHEN = 0 THEN 0 ELSE ROUND(/, 0)* END) (CASE WHEN IS NULL THEN NULL ELSE CASE WHEN = 0 THEN 0 ELSE ROUND(/, 0)* END END) CEIL() (CASE WHEN = 0 THEN 0 ELSE CEIL(/)* END) (CASE WHEN IS NULL THEN NULL ELSE CASE WHEN = 0 THEN 0 ELSE CEIL(/)* END END) CEIL() (CASE WHEN = 0 THEN 0 ELSE CEIL(/ABS())*ABS() END) (CASE WHEN IS NULL THEN NULL ELSE CASE WHEN = 0 THEN 0 ELSE CEIL(/ABS())*ABS() END END) COALESCE(, 0) COALESCE(, 0) SUBSTR(, , ) COALESCE(, 0) SUBSTR(, 1, ) SUBSTR(, CHARACTER_LENGTH() - + 1, ) RPAD('', CHARACTER_LENGTH() * , ) COALESCE(, '') COALESCE(, '') ( || ) COALESCE(, '') COALESCE(, '') OREPLACE(, , ) COALESCE(, '') COALESCE(, '') POSITION( IN ( (NOT CASESPECIFIC))) INSTR(UPPER(), UPPER(), ) (CASE WHEN INSTR(UPPER(), UPPER(), ) > 0 THEN INSTR(UPPER(), UPPER(), ) ELSE END) REGEXP_INSTR(, , , 1, 0, 'i') (CASE WHEN REGEXP_INSTR(, , , 1, 0, 'i') > 0 THEN REGEXP_INSTR(, , , 1, 0, 'i') ELSE END) Cartridge error: The first parameter of OpSEARCH/OpPATTERNSEARCH is expected to be a constant string. POSITION( IN ( (CASESPECIFIC))) INSTR(, , ) (CASE WHEN INSTR(, , ) > 0 THEN INSTR(, , ) ELSE END) EXTRACT(YEAR FROM ) EXTRACT(MONTH FROM ) EXTRACT(DAY FROM ) (WEEKNUMBER_OF_YEAR(, 'Teradata') + CASE WHEN WEEKNUMBER_OF_YEAR(CAST((EXTRACT(YEAR FROM ) - 1900) * 10000 + 101 AS DATE)) = 0 THEN 1 ELSE 0 END) WEEKNUMBER_OF_YEAR(, 'ISO') Cartridge error: Unsupported parameters for OpWEEKNUM. DAYNUMBER_OF_WEEK(, 'Teradata') DAYNUMBER_OF_WEEK(, 'ISO') DAYNUMBER_OF_WEEK( - INTERVAL '2' DAY, 'Teradata') DAYNUMBER_OF_WEEK( - INTERVAL '3' DAY, 'Teradata') DAYNUMBER_OF_WEEK( - INTERVAL '4' DAY, 'Teradata') DAYNUMBER_OF_WEEK( - INTERVAL '5' DAY, 'Teradata') DAYNUMBER_OF_WEEK( - INTERVAL '6' DAY, 'Teradata') (DAYNUMBER_OF_WEEK( - INTERVAL '1' DAY, 'Teradata') - 1) Cartridge error: Unsupported parameters for OpWEEKDAY. EXTRACT(HOUR FROM ) EXTRACT(MINUTE FROM ) EXTRACT(SECOND FROM ) CAST(( - 1900) * 10000 + * 100 + AS DATE) COALESCE(, 0) COALESCE(, 0) COALESCE(, 0) (timestamp'1899-12-30 00:00:00' + CAST( AS INTERVAL HOUR) + CAST( AS INTERVAL MINUTE) + CAST( AS INTERVAL SECOND)) COALESCE(, 0) ADD_MONTHS(, ) LAST_DAY(ADD_MONTHS(, )) 1=1 1 1=0 0 CAST( AS ) '1899-12-30' '1899-12-30 00:00:00.000' '1899-12-31 00:00:00.000' '0000 00:00:01.000000' ((CAST( as DATE) - CAST( AS DATE)) + CAST(EXTRACT(HOUR from ) AS DOUBLE PRECISION) /24 + CAST(EXTRACT(MINUTE from ) AS DOUBLE PRECISION)/(1440) + CAST(EXTRACT(SECOND from ) AS DOUBLE PRECISION)/(86400)) CAST(CASE WHEN THEN 1 ELSE 0 END AS FLOAT) (EXTRACT(DAY FROM ) + EXTRACT(HOUR FROM ) / 2.4E1) (EXTRACT(DAY FROM ) + (EXTRACT(HOUR FROM ) * 60 + EXTRACT(MINUTE FROM )) / 1.44E3) (EXTRACT(DAY FROM ) + (EXTRACT(HOUR FROM ) * 3600 + EXTRACT(MINUTE FROM ) * 60 + EXTRACT(SECOND FROM )) / 8.64E4) (CAST( AS FLOAT) / 2.4E1) ((EXTRACT(HOUR FROM ) * 60 + EXTRACT(MINUTE FROM )) / 1.44E3) ((EXTRACT(HOUR FROM ) * 3600 + EXTRACT(MINUTE FROM ) * 60 + EXTRACT(SECOND FROM )) / 8.64E4) (CAST( AS FLOAT) / 1.44E3) ((EXTRACT(MINUTE FROM ) * 60 + EXTRACT(SECOND FROM )) / 8.64E4) (CAST( AS FLOAT) / 8.64E4) CAST( AS FLOAT) CAST( + CASE WHEN < 0 THEN -0.5 ELSE 0.5 END AS BIGINT) CAST( + CASE WHEN < 0 THEN -0.5 ELSE 0.5 END AS BIGINT) CAST(CASE WHEN THEN 1 ELSE 0 END AS BIGINT) CAST(ROUND( , 0) AS BIGINT) CAST( AS BIGINT) ((CAST( AS DATE) - CAST( AS DATE) AS DECIMAL(19, 4)) + CAST(EXTRACT(HOUR FROM ) AS DECIMAL(19, 4)) / 24 + CAST(EXTRACT(MINUTE FROM ) AS DECIMAL(19, 4))/(24*60) + CAST(EXTRACT(SECOND FROM ))/(24*60*60)) CAST(ROUND(, 4) AS DECIMAL(19, 4)) CAST(CASE WHEN THEN 1 ELSE 0 END AS DECIMAL(19, 4)) CAST(ROUND( , 4) AS DECIMAL(19, 4)) CAST( AS DECIMAL(19, 4)) ( <> CAST( AS TIMESTAMP)) (CAST( AS BYTEINT) = 1) ( <> 0) (CAST(CAST( AS DATE) - CAST( AS DATE) AS BYTEINT)) (CASE WHEN THEN 1 ELSE 0 END) CAST( AS BYTEINT) CAST(CASE WHEN THEN ELSE END AS TIMESTAMP) cast( AS TIMESTAMP) + (()*86400* INTERVAL DAY TO SECOND) CAST( AS TIMESTAMP) (CASE WHEN = 1 THEN (U&'TRUE' UESCAPE '&') ELSE (U&'FALSE' UESCAPE '&') END) (CASE WHEN THEN (U&'TRUE' UESCAPE '&') ELSE (U&'FALSE' UESCAPE '&') END) CAST( AS VARCHAR(4000)) CAST( AS ) tdtv2r41 cartridge error: OpCast: ResultType is not specified ( CASE WHEN THEN ELSE END ) COALESCE(, 0) ACOS() (1.5707963267949 - ATAN()) COS() COSH() (1 / TAN()) EXP() LN() LOG() ASIN() ATAN() ( * 5.72957795130823E1) COALESCE(, 0) ( - * FLOOR( / )) COALESCE(, '') COALESCE(, 0) COALESCE(, '') COALESCE(, 0) GREATEST(, ) LEAST(, ) COALESCE(, 0) COALESCE(, 0) (LN() / LN()) ( * 1.74532925199433E-2) SIN() SINH() SQRT( * 3.14159265358979E0) TAN()