I'm having trouble inserting a date into mssql and am not sure if I'm using the proper format.
The type of field in mssql is smalldatetime
I get the date in php
$submitdate = date( "m/d/y");
and try to insert the variable $submitdate into the datbase
or I just type a string "01/05/01" in the insert into statement and when I look at the values in the database, it always lists today's date and no time. Even if I try to insert a totally different date I still get today's date with no time.
Also once I get it inserted, how do I run queries against it to find a specific date, do I need to format the date I'm looking for a certain way so mssql recognizes it?
Thanks,
Aaron
