query datetime string with time value

Question

i have a datetime string in my DB like "2010-08-15 00:00:00" how do i query only the time part. suppose i want to retrieve all rows that have the time "00:20:00"?

a1ex07 · Accepted Answer · 2010-10-12 16:20:09Z

2

WHERE TIME(datetimefield) = '00:00:00'

answered Oct 12, 2010 at 16:20

a1ex07

37.4k12 gold badges94 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

OMG Ponies · Accepted Answer · 2010-10-12 16:21:33Z

1

WHERE DATE_FORMAT('2007-10-04 22:23:00', '%H:%i:%s') = '00:20:00'

edited Oct 12, 2010 at 16:21

OMG Ponies

334k85 gold badges536 silver badges509 bronze badges

answered Oct 12, 2010 at 16:17

ITroubs

11.2k4 gold badges30 silver badges25 bronze badges

Collectives™ on Stack Overflow

query datetime string with time value

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related