MariaDB

MariaDB

Get current date in ~ms:

UNIX_TIMESTAMP(SUBTIME(UTC_TIMESTAMP(),'1 0:0:0.0')) * 1000;