Help Center/ Data Warehouse Service / More Documents/ Tool Guide (Kuala Lumpur Region)/ DSC/ Migrating MySQL Syntax/ Data Manipulation Language (DML)/ INTERVAL
Updated on 2025-10-14 GMT+08:00
View PDF
Share

INTERVAL

In MySQL, the interval expression format is INTERVAL N, which is not supported by DWS and needs to be converted to INTERVAL'N'.

Input

1
2
3
4
5
6
 
SELECT CURRENT_TIME() - INTERVAL 4 DAY;
SELECT NOW() - INTERVAL 5 HOUR;
SELECT CURRENT_TIME() - INTERVAL '4' DAY;
SELECT NOW() - INTERVAL '5' HOUR;
SELECT CURRENT_TIME() - INTERVAL "4" DAY;
SELECT NOW() - INTERVAL "5" HOUR;

Output

1
2
3
4
5
6
 
SELECT  (CURRENT_TIME () - INTERVAL '4' DAY);
SELECT  (NOW () - INTERVAL '5' HOUR);
SELECT  (CURRENT_TIME () - INTERVAL '4' DAY);
SELECT  (NOW () - INTERVAL '5' HOUR);
SELECT  (CURRENT_TIME () - INTERVAL '4' DAY);
SELECT  (NOW () - INTERVAL '5' HOUR);