I'm new in PHP and MySql. I'm looking for the time type syntaxe but I haven't found.
The Time type by default stores in the following format : HH:MM:SS, but I need to store just HH:MM. How can I define this .
:?:
TIA
Joao Carlos
time time using MySql
Moderator: General Moderators
time functions
http://www.mysql.com/doc/en/Date_and_ti ... tions.html
ie
SELECT DATE_FORMAT(timeField, "%H%i") FROM someTable WHERE someColumn=someValue
should return hours and minutes.
You can do the same syntax for and insert or update.
phpScott
ie
SELECT DATE_FORMAT(timeField, "%H%i") FROM someTable WHERE someColumn=someValue
should return hours and minutes.
You can do the same syntax for and insert or update.
phpScott