DavidArchibald
IS-IT--Management
Ahhhhhh, another fool who is struggling on this old chestnut!
I have a Datetime field in a SQL Server 7 table with a valid date in US format eg 9/25/2002.
The ASP/web server converts this to UK format (our locale format).
Even when I convert the date to US format, the recordset is empty.
SOO, what's the simplest way in the above scenario to do the following -
SELECT * FROM table_name WHERE table_field = date
Thanks in advance.
I have a Datetime field in a SQL Server 7 table with a valid date in US format eg 9/25/2002.
The ASP/web server converts this to UK format (our locale format).
Even when I convert the date to US format, the recordset is empty.
SOO, what's the simplest way in the above scenario to do the following -
SELECT * FROM table_name WHERE table_field = date
Thanks in advance.