UPDATE -- I think I have this figured out (Why SQL server is like this is beyond me). Styles was the problem. Anyway, here it is:<BR><BR>WHERE DateTime = CONVERT (CHAR (23), '2004-01-20 17:15:56 ...

..nervermind, got it.<br><br>convert (varchar (10), [date_field], 120)<br><br>does that mean though that I stuck with one of the ~20 predefined date formats ??<br><br>edit : in at the same time ...

This article provides an introduction to the most commonly used, nonstandard extensions in Oracle and how you can convert them for SQL Server compliance.