How to insert Date into mysql

[jimcarry05]

Hello guys, I am working on a project. And I want to insert the expiry date of the products. So how can I insert the expiry date into mysql using PHP script.

Thanks

 

[premiso]

If I am not mistaken, you can do something like:

 

INSERT INTO table (date_field, other_field) VALUES (DATE_ADD(NOW(), INTERVAL 1 DAY), 'other field stuff');

 

References:

MySQL Date and Time Functions

[jimcarry05]

Thanks :-)

[jimcarry05]

Hello, When I run this code. It stored 0000-00-00 on my database.

Here is PHP CODE

$date = $_GET["date"];
$query = "INSERT INTO tablename (col_name, col_date) VALUES ('Manual Date', '$date')";

And here is HTML

Date:
<input name="date" type="text">

Please correct this code. Thanks

[rajivgonsalves]

you will have to make sure that the date is in YYYY-MM-DD format e.g 2010-01-05 for it to insert properly otherwise it will be invalid and a 0000-00-00 date will be inserted

[jimcarry05]

I am inserting date in this format YYYY-MM-DD.

eg. 2010-01-01

 

[rajivgonsalves]

you'll have to check your query try

echo $query;

 

and see if its showing up correctly, also what is the column type for col_date

 

[jimcarry05]

Solved. Any mod here ?

Please close this thread.........................

 

[premiso]

You can close it by clicking the "Mark Solved" button on top left hand corner of the "Quick Reply".