DECLARE crunchCounter BIGINT DEFAULT UNIX_MILLIS() - 1530000000000; SELECT crunchCounter FROM DUAL; This does not work - variables only work for PL/SQL.
DECLARE crunchCounter BIGINT DEFAULT UNIX_MILLIS() - 1530000000000;
SELECT crunchCounter FROM DUAL;
This does not work - variables only work for PL/SQL.