Why would you not simply use a 'datetime' field type? This gets you exactly what you are looking for unless I am misreading what you are doing here... Scott Nipp Phone: (214) 858-1289 E-mail: sn4265@xxxxxxx Web: http:\\ldsa.sbcld.sbc.com -----Original Message----- From: Bomgardner, Mark A [mailto:mbomgardner@xxxxxxxxx] Sent: Thursday, October 28, 2004 10:10 AM To: php-db@xxxxxxxxxxxxx Subject: Time Field 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 event? Mark A. Bomgardner Technology Specialist KLETC -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
