insert date !!!

[had1980]

when i use echo $date the output is exactly like i want (for exemple 18/05/2001), but when i put mysql_query("insert ... $date), the result in the databse is completly different(for the mentioned exemple 2000-00-18) !!!!
I tried all the date format (Y-m-d, d-m-Y,...) and none of them worked properly.

thanks.

[ereptur]

Databases hold the date in a different format. The date format for most db servers is YYYY-MM-DD. It takes a little while to get used to it, but it's not too bad.

[keith73]

Originally posted by had1980
when i use echo $date the output is exactly like i want (for exemple 18/05/2001), but when i put mysql_query("insert ... $date), the result in the databse is completly different(for the mentioned exemple 2000-00-18) !!!!
I tried all the date format (Y-m-d, d-m-Y,...) and none of them worked properly.

thanks.

where is the date 18/05/2001 coming from. You may need to split it using the / as the separator and rearrange it into YYYY-MM-DD format.

• keith