RE: [PHP-DEV] RE: [PHP-DB] PHP and MySQL queries...
| From: | Robinson, Mike | Date: | Thu, 25 Oct 2001 15:30:30 +0000 |
| Subject: | RE: [PHP-DEV] RE: [PHP-DB] PHP and MySQL queries... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-13717@lists.php.net to get a copy of this message | ||
http://mysql.com/documentation/mysql/bychapter/manual_Reference.html#Date_an
d_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: mrobinson@torontostartv.com
Tim Foster wrote:
> If there's something about PHP/MySQL that makes this point
> moot, please let me know.