# Combine date and time in mysql

**URL:** <https://www.ruby-forum.com/t/combine-date-and-time-in-mysql/150963>\
**Category:** Rails\
**Created:** [October 15, 2008, 10:53am UTC](https://www.ruby-forum.com/t/combine-date-and-time-in-mysql/150963 "2008-10-15T10:53:57Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![paulbutcher](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/a5b964/32.png) [@paulbutcher](https://www.ruby-forum.com/u/paulbutcher)\
**Post date:** [October 15, 2008, 10:53am UTC](https://www.ruby-forum.com/t/combine-date-and-time-in-mysql/150963/1 "2008-10-15T10:53:57Z")

</div>

I have a date from a calendar\_date\_select and a time from a time\_select.  
They go to a date field and a time field in mysql. How do I combine time  
and date on both sides to make a comparison in a find?

I think this is on the right path, right?

DATE\_ADD(start\_date, INTERVAL start\_time HOUR\_SECOND)