date issue with MsSql
| From: | Jeffrey_N_Dyke at Keane dot com | Date: | Tue, 02 Jul 2002 21:40:45 +0000 |
| Subject: | date issue with MsSql | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20280@lists.php.net to get a copy of this message | ||
I'm posting info into a SQL Server from a form, all has been working fine
inserting, updating and selecting information for months. I have recently
added a date field to the table with the type of datetime. It updates the
table in SQL Server fine, but it keeps pulling it back as this date [Feb 07
2036 06:30AM]. for an example i put in a date of 01/01/2001(which is what
is in the Database)???? it doesn't matter the date that i'm inputting, it
always brings back the same date.
set up - solaris 8/Apache/SQLServer 7/PHP4.12
any ideas?
Thanks
Jeff