Solved! Go to Solution.
right format is,"Datefield" = date 'yyyy-mm-dd'
the sql is,"insert into TB1(ClmD) values(date '2012-1-1')"
http://help.arcgis.com/en/arcgisdesktop/10.0/help/#/SQL_reference_for_query_expressions_used_in_ArcG...
this page has the detail about query expressions