in date format how do i write my d.o.b. as dd/mm/yyyy

[fenwicks]

my d.o.b is required in dd,mm,yyyy i wrote 02.07.1956 but keeps coming back as invalid date format please correct ,It is for digital trends panel

[PreethiGowri]

MySQL's default DATE field format is YYYY-MM-DD. The supported range is 1000-01-01 to 9999-12-31.

So you have to insert like;

Insert into table_name values('2013-02-06');