Re: messing with dates
| From: | Larry E. Ullman | Date: | Mon, 12 May 2003 22:59:47 +0000 |
| Subject: | Re: messing with dates | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27684@lists.php.net to get a copy of this message | ||
i have a table where the dates are stored as a string like 5/12/03 - there are a few hundred records and i need to convert them to be stored in the date('U') format. anyone show me a quick and easy way to do this? db is mysql. thanks.Check out MySQL's DATE_FORMAT() function. Larry