I am using INSERT query for inserting current date in the mssql database table that contains date as datatype.....
I am using this method
echo $date_curr = date("d/m/y");
$sql_insert_rhrs = "INSERT INTO running_hrs1 (site_id, eb_time, bb_time, dg_time, r_date) VALUES ('$siteid', '0', '0', '0', '$date_curr')";// WARNING LINE
$result_insert_rhrs = mssql_query($sql_insert_rhrs);
Warning: mssql_query() [function.mssql-query]: message: Conversion failed when converting date and/or time from character string. (severity 16)
...
Go to the complete details ...