Re: date for mysql
| From: | Eugene Lee | Date: | Fri, 17 Oct 2003 13:46:32 +0000 |
| Subject: | Re: date for mysql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-166462@lists.php.net to get a copy of this message | ||
On Fri, Oct 17, 2003 at 03:28:50PM +0200, Diana Castillo wrote:
:
: how can I format the current date and time so that I can insert it into a
: mysql table with an insert query?
That depends on the column type of your MySQL table. Is it a DATETIME?
DATE? TIMESTAMP? TIME? Or just a YEAR?
http://www.mysql.com/doc/en/Date_and_time_types.html
Once you know the column type and its format, you can use PHP's date()
function to do the correcting formatting for MySQL.