date format

[guess]

while creating a data field in a table in mysql, I want to format the date like

dd/mm/yyyy

anybody helps??

[NogDog]

Best bet is to create a standard date or datetime type of column, then use STR_TO_DATE() when inserting/updating and DATE_FORMAT() when selecting from the database. (See http://dev.mysql.com/doc/refman/4.1/...functions.html for more info.)

[guess]

I must use that function in php. my value to convert is {$values3[$k][0]}

and the format must be '%d%m%Y'

I have tried lots but couldnt find.If u can write me the correct code, I would be glad...

this was my code

$query = "Insert into t1(rowcount,date1,time1,stats,queue,recvfrom,fromm,tto,subj,spam,rule) 
values($k+1,STR_TO_DATE('{$values3[$k][0]}','%m/%d/%Y'),'{$values3[$k][1]}','{$values2[$k][1]}','{$values2[$k][5]}',
'{$values2[$k][2]}','{$values2[$k][6]}','{$values2[$k][7]}',\"{$values2[$k][3]}\",\"{$values2[$k][4]}\",
\"{$values2[$k][8]}\")";