salix/db/dump/mockDate.sql

18 lines
322 B
MySQL
Raw Permalink Normal View History

DELIMITER $$
CREATE OR REPLACE DEFINER=`root`@`localhost` FUNCTION util.mockTime()
RETURNS DATETIME
DETERMINISTIC
BEGIN
RETURN @mockDate;
END$$
DELIMITER ;
DELIMITER $$
CREATE OR REPLACE DEFINER=`root`@`localhost` FUNCTION util.mockUtcTime()
RETURNS DATETIME
DETERMINISTIC
2023-05-16 13:00:31 +00:00
BEGIN
RETURN @mockDate;
END$$
2023-05-16 13:00:31 +00:00
DELIMITER ;