trying to convert date... having trouble

[bliss322]

i'm trying to insert a date into mysql.

the date format, originally, is m/d/y . i want to convert it to Y/m/d for MySQL insert.

when i try to convert it, it defaults to 1969-12-31 (from 01/03/03)

help?

code sample:

$endDate = $_POST["endDate"];

$endDate = getdate($endDate);

$year = $endDate['year'];

$month = $endDate['mon'];

$mday = $endDate['mday'];

$endDate = $year ."-". $month ."-". $mday;

[common_ground]

I dont think getdate($endDate) is doing what you think it does getdate expects a timestamp which is an integer.
you can split a string into an array parts using the explode function

[Thora_Fan]

You could try:

$endDate = date("Y-m-d", strtotime($_POST["endDate"]));

I had that problem a lot using the DATE type in MySQL.

[jmarco]

I'm sorry, I didn't read the question all the way. Do what the others said.