Select mysql query between date

Question

How to select data from mysql table past date to current date  For example  Select data from 1 january 2009 until current date     My column  datetime  is in datetime date type  Please help  thanks  Edit   If let say i want to get day per day data from 1 january 2009  how to write the query  Use count and between function

User · Accepted Answer

select   from  table name  where  datetime column  between  01 01 2009  and curdate     or using  gt   and  lt      select   from  table name  where  datetime column   gt    01 01 2009  and  datetime column   lt   curdate

User · Answer

Late answer  but the accepted answer didn t work for me  If you set both start and end dates manually  not using curdate     make sure to specify the hours  minutes and seconds  2019-12-02 23 59 59  on the end date or you won t get any results from that day  i e    This WILL include records from 2019-12-02   SELECT  SOMEFIELDS  FROM  YOURTABLE  where  YOURDATEFIELD  between  2019-12-01  and  2019-12-02 23 59 59    This WON T include records from 2019-12-02   SELECT  SOMEFIELDS  FROM  YOURTABLE  where  YOURDATEFIELD  between  2019-12-01  and  2019-12-02

User · Answer

All the above works  and here is another way if you just want to number of days time back rather a entering date  select   from  table name  where  datetime column  BETWEEN DATE SUB NOW    INTERVAL 30 DAY   AND NOW

User · Answer

You can use now   like   Select data from tablename where datetime  gt    01-01-2009 00 00 00  and datetime  lt   now

[mysql] Select mysql query between date?

Examples related to mysql

Examples related to select

Examples related to date