Query Problem

[dageshi]

I have a table with a datetime column in it e.g.

2004-12-01 22:05:00

I want to be able to run an sql query to match the time only on that column e.g. I would like to be able to return all entries which have the 22:05:00 time, irrespective of the date element of the field.

So far I've not been able to track down precisely how to do this does anyone have any suggestions?

Thx

[Xnuiem]

http://www.signal42.com/mirrors/mysql/doc/...ESTAMP_4.1.html

I never use the date field, it is often better to just store the seconds since epoch in an INT(16) field. Much easier to deal with.

http://dev.mysql.com/doc/mysql/en/Date_and..._functions.html and look at curtime