Datetime equal or greater than today in MySQL

Question

What s the best way to do following   SELECT   FROM users WHERE created  gt   today    Note  created is a datetime field

User · Answer

SELECT   FROM table name WHERE CONCAT  SUBSTRING json date  11  4       -   SUBSTRING  json date  7  2       -   SUBSTRING json date  3  2      gt   NOW      json date   05 11 2011

User · Answer

you can return all rows and than use php datediff function inside an if statement  although that will put extra load on the server   if dateDiff date  Y m d     row  date     lt  0         else      echo   info here

User · Answer

SELECT   FROM users WHERE created  gt   now

User · Answer

If  created  is datetime type  SELECT   FROM users WHERE created  lt  DATE ADD CURDATE    INTERVAL 1 DAY     CURDATE   means also  2013-05-09 00 00 00

User · Answer

SELECT   FROM users WHERE created  gt   CURDATE      But I think you mean created  lt  today

User · Answer

If the column have index and a function is applied on the column then index doesn t work and full table scan occurs  causing really slow query  Bad Query  This would ignore index on the column date time select   from users where Date date time   gt   2010-10-10   To utilize index on column created of type datetime comparing with today current date  the following method can be used  Solution for OP  select   from users where created  gt  CONCAT CURDATE      23 59 59    Sample to get data for today  select   from users where      created  gt   CONCAT CURDATE      00 00 00   AND     created  lt   CONCAT CURDATE      23 59 59    Or use BETWEEN for short select   from users  where created BETWEEN        CONCAT CURDATE      00 00 00   AND CONCAT CURDATE      23 59 59    Tip  If you have to do a lot of calculation or queries on dates as well as time  then it s very useful to save date and time in separate columns   Divide  amp  Conquer

User · Answer

Answer marked is misleading  The question stated is DateTime  but stated what was needed was just CURDATE     The shortest and correct answer to this is   SELECT   FROM users WHERE created  gt   CURRENT TIMESTAMP

User · Answer

SELECT   FROM users WHERE created  gt   NOW      if the column is datetime type

User · Answer

The below code worked for me   declare  Today date  Set  Today getdate   --date will equal today      Select    FROM table name WHERE created  lt    Today

User · Answer

SELECT   FROM myTable WHERE  DATE myDate    DATE NOW      Read more    http   www tomjepson co uk tutorials 36 mysql-select-where-date-today html

[mysql] Datetime equal or greater than today in MySQL

Examples related to mysql

Examples related to sql

Examples related to datetime