can't insert into mssql smalldatetime
| From: | aaron | Date: | Fri, 09 Nov 2001 21:13:23 +0000 |
| Subject: | can't insert into mssql smalldatetime | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-74057@lists.php.net to get a copy of this message | ||
I have this query
$db1 = "INSERT INTO tablename
(name,email,phone,room,problem,upgrade,software,hardware,printer,network,os,
priority,submitdate)
VALUES
('$name','$email','$phone','$room','$problem','$upgrade','$software','$hardw
are','$printer','$network','$os','$priority','1996-05-01')";
$cur1 = MSSQL_QUERY($db1);
But when I do a select of the submitdate field, it always turns up as
today's date no matter what I try to insert. Do I need to change the format
of my date before I insert it somehow? The submitdate field is of type
smalldatetime
Thanks,
Aaron