Inserting user-entered date into MSSQL with PHP

[Molly_Jones]

I've read everything I can and am still having problems. I think I am just stupid.

Here's what I'm trying to do. The user is filling out a web form with many dates. I want to enter those dates into a MSSQL db as dates, not varchar, so I can process with. I feel like I've tried everything and am going into circles. Here's what I have right now:

$month = $GET['month'];
$day = $GET['day'];
$year = $_GET['year'];
$date = $year.$month.$day;
$newdate = date("ymd", $date);

$query="INSERT INTO test (date) VALUES ($newdate)";

["date" is a datetime type column. I have also tried timestamp and smdatetime to no avail.]

No matter what is entered from the web side, this is what is inserted: Jul 11 3792 12:00AM

what in *@&($ am I doing wrong?

[NogDog]

How about this?

// use standard YYYY-mm-dd format:
$newdate = sprintf('%04d-%02d-%02d', $_GET['year'], $_GET['month'], $_GET['day']);
// quote the value in the SQL:
$query="INSERT INTO test (date) VALUES ('$newdate')";

[Molly_Jones]

made that change, entered Oct 18, 2011 and get this inserted: Apr 26 1905 12:00AM arrgghh!

the date values are coming as digits from html (10-18-2011, e.g.)

[NogDog]

Afraid I'm not experienced with MS SQL. Maybe its default date format is different than MySQL's? Guess I'll have to defer to a MS SQL expert. 🙁

[Molly_Jones]

That's what I'm thinking too. . . stupid microsoft.

thank you for your help though.