MySQL NOW() Function: Examples

Back Home

Examples
Sample Database

#1

SELECT NOW();

#2

SELECT NOW() + 0;

#3

SELECT NOW(), SLEEP(5), NOW();

#4

SELECT SYSDATE(), SLEEP(5), SYSDATE();

#5

       -- mysql now minus 1 hour
SELECT (NOW() - INTERVAL 1 HOUR) 'NOW - 1 hour',
        NOW(),
       -- mysql now plus 1 hour
       NOW() + INTERVAL 1 HOUR 'NOW + 1 hour';

#6

        -- mysql now minus 1 day
SELECT (NOW() - INTERVAL 1 DAY) 'NOW - 1 day',
        NOW(),
        -- mysql now plus 1 day
        (NOW() + INTERVAL 1 DAY) 'NOW + 1 day';

Table List