Best to use int field type and store the difference between the unix timestamp start time and the unix timestamp end time (both seconds since the epoch) which would be the number of seconds it took to complete the task. This number can then be manipulated with math to provide elapsed times in hours/minutes//seconds...



From: "Bomgardner, Mark A" <[EMAIL PROTECTED]>
Subject: [PHP-DB] Time Field
Date: Thu, 28 Oct 2004 10:10:19 -0500

When creating a time field in MySQL, its purpose is for elapsed time,
not time of day.  Is it better to use this field or to combine it with
the date field when looking at inserting the start date and time of an

Mark A. Bomgardner
Technology Specialist

-- PHP Database Mailing List ( To unsubscribe, visit:

Reply via email to