Title: RE: [PHP-DEV] RE: [PHP-DB] PHP and MySQL queries...

http://mysql.com/documentation/mysql/bychapter/manual_Reference.html#Date_and_time_types

Mysql permits all manner of formats for date/time storage,
and a whole slew of functions for retrieving date/time
info in useful, meaningful ways.

For me, parsing date/time stuff before an insert or after a
select is just plain bad practice, IMHO, when the data can go
in and out in the format required without parsing, particularly
with resource-costly tools like regex and the like.

Date/time select controls (I think there's some on devshed
and/or Zend) and mysql's built-in date/time functions rock.


 Mike Robinson
 IT / Developer - Toronto Star TV
 Phone: 416.945.8786
 Fax: 416.869.4566
 Email: [EMAIL PROTECTED]


Tim Foster wrote:

> If there's something about PHP/MySQL that makes this point
> moot, please let me know.

http://www.torontostartv.com - Webcasting & Production
http://www.tmgtv.ca - Hometown Television
http://www.thestar.com - Canada’s largest daily newspaper, The Toronto Star, online

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to