mysql数据库datetime字段,只需要从datetime字段获取MySQL数据库中的记录

This seems rather simple but it has been giving me a headache. I have a column in my events table that is called 'date_time' and it's type is datetime.

I need to write a query that will get events by day.

Example of table

============================

| id | date_time |

============================

| 5 | 2009-03-27 14:16:00 |

============================

Now I need to get the event with the Id = 5, except I only have a date (unix timestamp) to work with. I have tried many things such as converting to mysql format and selecting between 2009-03-27 00:00:00 and 2009-03-28 00:00:00 but I couldn't get it to work.

What is the best way to do this?

Thanks muchly.

解决方案SELECT * FROM table

WHERE date_time BETWEEN '2009-03-27 00:00:00' AND '2009-03-27 23:59:59'

Should do it.

Alternatively, try this:

SELECT * FROM table WHERE DATE(date_time) = '2009-03-27'

The DATE() function extracts the date part of the datetime column.