Insert date to mysql from php

Question

Am trying to insert date to a MYSQL column with datatype DATE . the following code is used.

$expiry = date("Y-m-d H:i:s", $_POST['expiry']);

but the mysql column shows 01-Jan-70 12:00:00 AM . have also used strtotime() but it seems to insert NULL.

The html input takes YYYY-MM-DD as date format input

any help appreciated.

That date format doesn't match MySQL native date format. Are you sure that's right? — John Conde, Feb 22 '14 at 14:17
thank you for the answer. am actually not sure. kindly tell which format to use — Abdul Ali, Feb 22 '14 at 14:17
`DATE` uses `YYYY-MM-DD`, `DATETIME` (eg) `YYYY-MM-DD HH:MM:SS`, see the [doc](https://dev.mysql.com/doc/refman/5.1/en/date-and-time-literals.html) — kero, Feb 22 '14 at 14:18
good answer is http://stackoverflow.com/questions/12120433/php-mysql-insert-date-format — Wasim, Feb 22 '14 at 14:19
Could you show use the `Table information` and the `SQL Insert statement` ? — Orel Eraki, Feb 22 '14 at 14:19
am actually adding a new parameter to a already built (long code) of php web service. — Abdul Ali, Feb 22 '14 at 14:24
try to print $_POST and check whether it holds value for "expiry" or not — Snehal S, Feb 22 '14 at 14:28

score 0 · Accepted Answer · answered Feb 22 '14 at 14:28

thank you for the comments. although all comments may likely be helpful but Wasim's link seemed to provide the solution:

have simply saved the date in a variable without any transformations as follows:

$expiry = $_POST['expiry']; // $_POST['expiry'] = YYYY-MM-DD

thank you for all the help though..

1 Answers1