# Comparing Datetime to datetime in mysql

**URL:** <https://www.ruby-forum.com/t/comparing-datetime-to-datetime-in-mysql/145903>\
**Category:** Rails\
**Created:** [August 14, 2008, 10:01pm UTC](https://www.ruby-forum.com/t/comparing-datetime-to-datetime-in-mysql/145903 "2008-08-14T22:01:08Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![morgan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/0ea827/32.png) [@morgan](https://www.ruby-forum.com/u/morgan)\
**Post date:** [August 14, 2008, 10:01pm UTC](https://www.ruby-forum.com/t/comparing-datetime-to-datetime-in-mysql/145903/1 "2008-08-14T22:01:08Z")

</div>

i have a field in an mysql database that has a mysql date and time.

i would like to be able to get a date range and a time range is  
possible…

say i just want to get the records that are january 14th from 4:00 to  
18:00

2008-08-11 10:00:00 this is what the timestamps look like.

---

<div class="post-metadata">

**Author:** ![morgan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/0ea827/32.png) [@morgan](https://www.ruby-forum.com/u/morgan)\
**Post date:** [August 15, 2008, 1:37pm UTC](https://www.ruby-forum.com/t/comparing-datetime-to-datetime-in-mysql/145903/2 "2008-08-15T13:37:48Z")

</div>

Try :conditions =\> [‘created\_at BETWEEN ? AND ?’, time1, time2]

On Aug 14, 11:01 pm, Morgan M. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)