Sunday, August 10, 2008

How Mysql TIME data type works with php

Lets see what is the format that is accepted by Mysql TIME data type.
Normal format: HH:MM:SS
Extended hour format: HHH:MM:SS - This is larger than 23 hours because its used to store time between two points.

It's better if you use above formats to store your time manually

INSERT INTO your_tbl VALUES ('14:26:05')

Get Free Sinhala IT Learning Videos

 Subscribe To My Blog

No comments:

Post a Comment