MySQL:Simple Help nedded

pullez

Hi every one:
I hope some of you guys can help me with this one:
I´m trying to insert a date retruned from a form field into a mysql date field,no matter what i try I always get the same result.

Mysql date fied loks like this 01.01.0001.

What I´m doing wrong? Can somebody help me.
Thaks a lot.

interactive

show me your code and ill try plz

pullez

Hold on,I will send it right away.
Thanks.

pullez

O.K:
My initial value looks like this:

$field_03=\"7/23/2002\";// and then I have tried
$field_03=eregi_replace(\"/\", \"-\",$field_03);
$field_03=explode(\"-\",$field_03);
$field_03=mktime(0,0,0,$field_03[2],$field_03[0],$field_03[1]);//Here trying to move the year to the begginig of the array but it return -1.
Thanks in advance fr any help.

interactive

are you trying to get the current date see i dont understnad your question and by the way
field_03=\"7/23/2002\";// and then I have tried is the same as
field_03="7/23/2002";// and then I have tried

interactive

you can try something like
echo date ("M-d-Y", mktime (0,0,0,1,1,98));

pullez

No I just want to invert the date format from this " 7/23/2002 " to this "2002-7-23" and then insert it into a mysql date field.I don´t need the current date at all.
thanks.

interactive

ok take $time would be your 7/23/2002
<?php

$exploded=explode("/",$time);
$time2=$exploded['2']."-".$exploded['0']."-".$exploded['1'];

pullez

Thanks a lot ,It did work! but i also find out that the format date for the month doesn´t have a 0 before the month number maybe that´s the reason Why I get then 01.01.0001 in mysql field.what do you think?
Thanks.

interactive

no idea im starting to get discouraged with php a lil bit i might go back to perl. Not knocking php and all its col just i know perl functions like the back of my hand.

burnz

Just change the date field to char or varchar field..

hope this will work..

metin

MySQL date field is in the form of 'YYYY-MM-DD'
Here is how you can convert a date in a given format (MM/DD/YYYY)
to another (DD.MM.YYYY)!
<?php
$date = '7/23/2002';
$time_stamp = strtotime($date);
$new_date = date("d.m.Y",$time_stamp);
echo $new_date;
?>

metin

Just to make it clear - for MySQL you would do:
<?php
$date = '7/23/2002';
$time_stamp = strtotime($date);
$new_date = date("Y-d-m",$time_stamp);
echo $new_date;
?>

... and the sql statement should be something like this:
$sql = "INSERT INTO table_name (date_field) VALUES ('$new_date')";