RE: [PHP-DEV] RE: [PHP-DB] PHP and MySQL queries...
| From: | Tim Foster | Date: | Thu, 25 Oct 2001 16:14:23 +0000 |
| Subject: | RE: [PHP-DEV] RE: [PHP-DB] PHP and MySQL queries... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13719@lists.php.net to get a copy of this message | ||
RE: [PHP-DEV] RE: [PHP-DB] PHP and MySQL queries...Agreed.
Personally, I refuse to keep date values in fields that are not DATE fields
of some kind. Too much trouble.
TIM
-How do "Do Not Walk On Grass" signs get there?
-----Original Message-----
From: Robinson, Mike [mailto:mrobinson@torontostartv.com]
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.