i want to store date in many fields of sql server 2000, the date field having the datatype datetime and i pass the value to the date field like below
Code:$now=date("m/d/Y h:i:s A"); mssql_bind($stmt,"@s_date", $var1,SQLINT4);
first variable got insert the now date successfully but other dates values didnt insert now value it store like 1/2/1900 12:00:00 AM
why it behave like this can any one suggest me answer to this
thanks
sona




Reply With Quote