Question 20876 in Mysql Question posted in
The official MySQL documentation can be found here.

SQL Select data in the last 1 minutes – Mysql

i am currently practicing my SQL skills. I wanted to get all data in the past 1 minutes.

The query is SELECT * FROM menfesses WHERE created_at >= NOW() - INTERVAL 1 MINUTE;
But somehow, it returns all data.

I have also use date_add approach and nothing works

What did i do wrong? Thanks

Query Result

Tags:

2

Answers


  1. 0

    The last five minutes must be select with a BETWEEN.

    Also testing you should add

    SELECT created_at, Now() FROM menfesses WHERE created_at BETWEEN NOW() - INTERVAL 5 MINUTE AND NOW()

    So that have a chance to debug it correctly

    Between would only give you the correct data, as your test server could have dates later then now

    Edit

    a fiddle demonstrates my point https://dbfiddle.uk/c5Jlko65

    You maybe off on the system you have

    Login or Signup to reply.
  2. 0

    Probably your server time that’s not what you think it is.

    This work with a 5 min laps.

    SQL Fiddle

    MySQL 5.6 Schema Setup:

    CREATE TABLE t1
    (`c_date` datetime)
;
    
INSERT INTO t1
    (`c_date`)
VALUES
    (NOW() - INTERVAL 30 MINUTE),
    (NOW() - INTERVAL 2 MINUTE),
    (NOW() - INTERVAL 1 MINUTE)
;

    Query 1:

    SELECT *,NOW() FROM t1 WHERE c_date >= NOW() - INTERVAL 5 MINUTE

    Results:

    |               c_date |                NOW() |
|----------------------|----------------------|
| 2023-02-09T15:44:05Z | 2023-02-09T15:46:20Z |
| 2023-02-09T15:45:05Z | 2023-02-09T15:46:20Z |
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search