date into mysql weirdness?

bliss322

i want to input a date into mysql from a form element

the date format is mm/dd/yy and I realize the mysql dates needs to be yyyy/mm/dd.

at first i tried to use the date function

$startDate = date("Y/m/d",$startDate);

the result was 1969/12/31 (not the date i had selected)

suggestions?

code sample: on a different topic, i couldn't access the variables until I actually used $_POST["variable"]... i thought i wouldn't need to declare post or get?

if ($_POST["submit"] == "Add News") {

$adTitle = $POST["adTitle"];
$adContent = $POST["adContent"];
$startDate = $POST["startDate"];
$endDate = $POST["endDate"];

$startDate = date("Y/m/d",$startDate);
$endDate = date("Y/m/d",$endDate);
echo $startDate."<br/ >";
echo $endDate."<br/ >";
}

cgraz

If i understand correctly, you want to input the current date into the database using mm/dd/yy format? NOW() is mysql's way of inputting the current time into the database, but it does use mysql's date format. if you want it to input as mm/dd/yy, use DATE_FORMAT() Make sure your'e using a date field


$query = mysql_query("INSERT INTO your_table (date_d) VALUES (DATE_FORMAT(now(), '%m %d %y'))");

Where date_d is your field name. That will input current time in the format mm dd yy (look at the link above, and search the page for date_format to find more ways to format the date). If you want the dashes in there, just add them between the %m %d and %y like so

'%m-%d-%y'

Cgraz