SQL dateTime field (WD21)

Hi,

I'm busy to convert some data from HyperFile to MSSQL.
In HyperFile I have a 'datetime' field.
I did translate it as a DateTime field in MSSQL.

When i run a query (SELECT TOP 10 * FROM ORDERS) on the MSSQL server (Microsoft SQL Server Management Studio) datetime field is presented as:
2012-01-19 09:24:26.280

In another database stored on a other machine I can do
SELECT *
from Orders
where OrderDate='20120119'

and then i get the records.

On this database, on my local machine, i get nothing.

Why ?

"2012-01-19 09:24:26.280" is NOT equal to '20120119', and the format has NOTHING to do with it...

One is a dateTIME, the other a date...