RE: [PHP-DB] Trouble retrieving DATETIME info from MSSQL - resolved

2001-10-02 Thread Matthew DeChant
, October 01, 2001 2:26 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Trouble retrieving DATETIME info from MSSQL Hello, I am having trouble getting data from a DATETIME field in MSSQL 7.0. The data in a general select query look like this: 2001-09-25 14:23:17.000 I can do this in MSSQL: select

[PHP-DB] Trouble retrieving DATETIME info from MSSQL

2001-10-01 Thread Matthew DeChant
Hello, I am having trouble getting data from a DATETIME field in MSSQL 7.0. The data in a general select query look like this: 2001-09-25 14:23:17.000 I can do this in MSSQL: select * from INTERNETLOG where Datetime like %2001% but not this: select * from INTERNETLOG where Datetime like