Mysql Time Range

Mysql Time Range is used to displays time values in 'HH:MM:SS' format, but helps you to assign values to Time columns using either strings numbers.

Mysql Time Range

Mysql Time Range

     

Mysql Time Range  is used to displays time values in 'HH:MM:SS' format, but helps you to assign values to Time columns using either strings numbers.

Understand with Example

The Tutorial illustrate an example from 'Mysql Time Range'. To understand example we create a table 'timetable' with fields and datatypes respectively .The table has a Primary Key id.

Create Table "timeTable"  :

CREATE TABLE `timetable` ( 
`id` bigint(20) NOT NULL auto_increment, 
`time_field` time default NULL, 
PRIMARY KEY (`id`) 
)

Query to select  time values :

To select and return the time _field records we run select query.

select time_field from timeTable;

Output :

+------------+
| time_field |
+------------+
| 10:10:10 |
+------------+
1 row in set (0.00 sec)