Comparing Times to One Another : Time « Date Time « SQL / MySQL






  1. SQL / MySQL
  2. Date Time
  3. Time

Comparing Times to One Another

     

WHERE t1 BETWEEN '09:00:00' AND '14:00:00';
WHERE HOUR(t1) BETWEEN 9 AND 14;








Related examples in the same category

1.Get Current time
2.Extract the entire time value by using the TIME() function: TIME(
3.TIME type column
4.Compare time value
5.Alias column for constant time value
6.Calculates the sum of the two TIME values
7.Return the total working time, using SUM.