Check out example codes for "how to search date in sql query". It will help you in understanding the concepts better.

Code Example 1

select * from test 
 where date between '03/19/2014' and '03/19/2014 23:59:59'

Code Example 2

select * from test 
 where datediff(day, date, '03/19/2014') = 0

Learn ReactJs, React Native from akashmittal.com