[MySQL] ' . . ' can't insert into a date field,but update can

Hi,
table table1 int1 int auto_increament ,
date date not null default '0000-00-00'

1) insert into table1 (date) values(' . . ')

// shows Incorrect date value: ' . . ' for column date' at row 1
// ' . . ' ==> space(4)+"."+space(2)+"."+space(2)

2) update table1 set date=' . . '

// this done .

I hope can insert a ' . . ' value to a date field .
Mysql 5.0.51

Regards!

Shuming Wang