STDDEV_SAMP(%1) NULL VAR_SAMP(%1) NULL DATE_FORMAT(%1, '%Y-%m-%d') DATE_FORMAT(%1, '%Y-%m-%d %H:%i:%s') CAST(%1 AS TIMESTAMP) TO_DAYS(%1) - 693961.0 CAST(%1 AS DOUBLE) CAST(%1 AS STRING) CAST(%1 AS STRING) CAST(%1 AS STRING) CASE WHEN ISNULL(%1) THEN NULL WHEN %1 = TRUE THEN '1' WHEN %1 = FALSE THEN '0' END CAST(%1 AS INT) CAST(%1 AS INT) CAST(CAST(%1 AS DOUBLE) AS INT) CASE WHEN ISNULL(%1) THEN CAST(DATE_FORMAT(%2, '%Y-%m-%d 00:00:00') AS TIMESTAMP) ELSE %1 END CASE WHEN ISNULL(%1) THEN %2 ELSE CAST(DATE_FORMAT(%1, '%Y-%m-%d 00:00:00') AS TIMESTAMP) END (%1 = CAST(DATE_FORMAT(%2, '%Y-%m-%d 00:00:00') AS TIMESTAMP)) (CAST(DATE_FORMAT(%1, '%Y-%m-%d 00:00:00') AS TIMESTAMP) = %2) (%1 = %2) (%1 AND NOT %2 OR NOT %1 AND %2) (%1 AND %2 = 0 OR NOT %1 AND %2 <> 0) (%1 <> %2) (%1 = 0 AND %2 OR %1 <> 0 AND NOT %2) (%1 <> %2) (%1 <> %2) (CAST(DATE_FORMAT(DATE(%1), '%Y-%m-%d 00:00:00') AS TIMESTAMP) <> %2) (%1 <> CAST(DATE_FORMAT(DATE(%2), '%Y-%m-%d 00:00:00') AS TIMESTAMP)) (%1 <> %2) (%1 > CAST(DATE_FORMAT(%2, '%Y-%m-%d 00:00:00') AS TIMESTAMP)) (CAST(DATE_FORMAT(%1, '%Y-%m-%d 00:00:00') AS TIMESTAMP) > %2) (%1 > %2) (%1 >= CAST(DATE_FORMAT(%2, '%Y-%m-%d 00:00:00') AS TIMESTAMP)) (CAST(DATE_FORMAT(%1, '%Y-%m-%d 00:00:00') AS TIMESTAMP) >= %2) (%1 >= %2) (%1 < CAST(DATE_FORMAT(%2, '%Y-%m-%d 00:00:00') AS TIMESTAMP)) (CAST(DATE_FORMAT(%1, '%Y-%m-%d 00:00:00') AS TIMESTAMP) < %2) (%1 < %2) (%1 <= CAST(DATE_FORMAT(%2, '%Y-%m-%d 00:00:00') AS TIMESTAMP)) (CAST(DATE_FORMAT(%1, '%Y-%m-%d 00:00:00') AS TIMESTAMP) <= %2) (%1 <= %2) DATE_ADD(%1, INTERVAL CAST((86400 * (%2)) AS INT) SECOND) DATE_ADD(%1, INTERVAL %2 DAY) DATE_ADD(%1, INTERVAL CAST((86400 * (%2)) AS INT) SECOND) ((%1) * -1) ((%1) * -1) ((TO_DAYS(%1) - TO_DAYS(%2)) + ((TIME_TO_SEC(%1) - TIME_TO_SEC(%2)) / 86400.0)) (unix_timestamp(%1) - unix_timestamp(%2)) / 86400 (unix_timestamp(%1) - unix_timestamp(%2)) / 86400 DATE_SUB(%1, INTERVAL CAST((86400 * (%2)) AS INT) SECOND) DATE_SUB(%1, INTERVAL %2 DAY) DATE_SUB(%1, INTERVAL CAST((86400 * (%2)) AS INT) SECOND) TO_DAYS(%1) - TO_DAYS(%2) CAST(%1 AS DOUBLE) / (%2) CASE WHEN %1 = 0 THEN NULL ELSE COT(%1) END CASE WHEN %2 = 0 THEN NULL ELSE ( (%1) / (%2) ) END CASE WHEN %2 = 0 THEN NULL ELSE ( (%1) / (%2) ) END (CASE WHEN %1 > 0 THEN LN(%1) ELSE NULL END) CASE WHEN %1 > 0 THEN LOG10(%1) ELSE NULL END CASE WHEN %1 > 0 AND %2 > 0 AND %2 <> 1 THEN LOG(%2,%1) ELSE NULL END CASE WHEN ISNULL(%1) THEN NULL WHEN ISNULL(%2) THEN NULL WHEN %1 > %2 THEN %1 ELSE %2 END CASE WHEN ISNULL(%1) THEN NULL WHEN ISNULL(%2) THEN NULL WHEN %1 > %2 THEN %1 ELSE %2 END CASE WHEN ISNULL(%1) THEN NULL WHEN ISNULL(%2) THEN NULL WHEN %1 > %2 THEN %1 ELSE %2 END CASE WHEN ISNULL(%1) THEN NULL WHEN ISNULL(%2) THEN NULL WHEN %1 > %2 THEN %1 ELSE %2 END CASE WHEN ISNULL(%1) THEN NULL WHEN ISNULL(%2) THEN NULL WHEN %1 > %2 THEN %1 ELSE %2 END CASE WHEN ISNULL(%1) THEN NULL WHEN ISNULL(%2) THEN NULL WHEN %1 < %2 THEN %1 ELSE %2 END CASE WHEN ISNULL(%1) THEN NULL WHEN ISNULL(%2) THEN NULL WHEN %1 < %2 THEN %1 ELSE %2 END CASE WHEN ISNULL(%1) THEN NULL WHEN ISNULL(%2) THEN NULL WHEN %1 < %2 THEN %1 ELSE %2 END CASE WHEN ISNULL(%1) THEN NULL WHEN ISNULL(%2) THEN NULL WHEN %1 < %2 THEN %1 ELSE %2 END CASE WHEN ISNULL(%1) THEN NULL WHEN ISNULL(%2) THEN NULL WHEN %1 < %2 THEN %1 ELSE %2 END CEIL(%1) FLOOR(%1) (((CASE WHEN (ABS((%2) - (CAST( ( (%2) / SQRT(3.0) ) AS INT ) * SQRT(3.0)))) + (SQRT(3.0) * ((ABS((%1) - (CAST( ( (%1) / 3.0 ) AS INT ) * 3.0))) - 1.0)) > 0.0 THEN 1.5 ELSE 0.0 END) - (CASE WHEN ((%1) - (CAST( ( (%1) / 3.0 ) AS INT ) * 3.0) < 0.0) AND ((CASE WHEN (ABS((%2) - (CAST( ( (%2) / SQRT(3.0) ) AS INT ) * SQRT(3.0)))) + (SQRT(3.0) * ((ABS((%1) - (CAST( ( (%1) / 3.0 ) AS INT ) * 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 INT ) * 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) DAY_OF_YEAR(%1) DAY_OF_MONTH(%1) DAY_OF_WEEK(%1) (CASE WHEN %2 >= 0 THEN LEFT(%1, CAST(%2 AS INT)) ELSE NULL END) (CASE WHEN %2 >= 0 THEN RIGHT(%1, CAST(%2 AS INT)) ELSE NULL END) SUBSTR(%1,%2) SUBSTR(%1,CAST(%2 as int)) SUBSTR(%1,%2,%3) SUBSTR(%1,CAST(%2 as int),%3) SUBSTR(%1,%2,CAST(%3 as int)) CASE WHEN %3 < 1 THEN '' WHEN %2 < 1 THEN SUBSTR(%1,1,CAST(%3 AS INT)) ELSE SUBSTR(%1,CAST(%2 AS INT),CAST(%3 AS INT)) END LOCATE(%2,%1,CAST(%3 as int)) LOCATE(%2,%1,%3) (YEAR(%3) - YEAR(%2)) ((YEAR(%3) - YEAR(%2)) * 4 + (QUARTER(%3) - QUARTER(%2))) ((YEAR(%3) - YEAR(%2)) * 12 + (MONTH(%3) - MONTH(%2))) (TO_DAYS(%3) - TO_DAYS(%2)) (TO_DAYS(%3) - TO_DAYS(%2)) (TO_DAYS(%3) - TO_DAYS(%2)) FLOOR(((TO_DAYS(%3) - (DAYOFWEEK(%3) - 1)) - (TO_DAYS(%2) - (DAYOFWEEK(%2) - 1)))/7) ((TO_DAYS(%3) - TO_DAYS(%2)) * 24 + FLOOR(TIME_TO_SEC(%3) / 3600) - FLOOR(TIME_TO_SEC(%2) / 3600)) ((TO_DAYS(%3) - TO_DAYS(%2)) * 1440 + FLOOR(TIME_TO_SEC(%3) / 60) - FLOOR(TIME_TO_SEC(%2) / 60)) ((TO_DAYS(%3) - TO_DAYS(%2)) * 86400 + (TIME_TO_SEC(%3) - TIME_TO_SEC(%2))) FLOOR((( TO_DAYS(%3) - ((7 + DAYOFWEEK(%3) - 2) % 7)) - (TO_DAYS(%2) - ((7 + DAYOFWEEK(%2) - 2) % 7) ) )/7) YEAR(%2) QUARTER(%2) MONTH(%2) DAYOFYEAR(%2) DAYOFMONTH(%2) DAYNAME(%2) FLOOR((7 + DAYOFYEAR(%2) - 1 + DAYOFWEEK(DATE_FORMAT(%2, '%Y-01-01 00:00:00')) - 1) / 7) HOUR(%2) MINUTE(%2) SECOND(%2) FLOOR((7 + DAYOFYEAR(%2) - 1 + ((7 + DAYOFWEEK(DATE_FORMAT(%2, '%Y-01-01 00:00:00')) - 2) % 7) ) / 7) DATE_FORMAT( %2, '%Y-01-01 00:00:00' ) CONCAT(DATE_FORMAT(%2, '%Y-'), CONCAT(CAST((3*(QUARTER(%2)-1)+1) AS STRING), '-01 00:00:00')) DATE_FORMAT( %2, '%Y-%m-01 00:00:00' ) DATE_FORMAT( %2, '%Y-%m-%d 00:00:00' ) DATE_FORMAT( %2, '%Y-%m-%d 00:00:00' ) DATE_FORMAT( %2, '%Y-%m-%d 00:00:00' ) FROM_DAYS( TO_DAYS(%2) - (DAYOFWEEK(%2) - 1)) DATE_FORMAT( %2, '%Y-%m-%d %H:00:00' ) DATE_FORMAT( %2, '%Y-%m-%d %H:%i:00' ) DATE_FORMAT( %2, '%Y-%m-%d %H:%i:%s' ) FROM_DAYS( TO_DAYS(%2) - ((7 + DAYOFWEEK(%2) - 2) % 7) )