Taken from BOL 2000: "Writing International Transact-SQL Statements"

ADO, OLE DB, and ODBC applications should use the ODBC timestamp, date, and time escape clauses of:

* { ts 'yyyy-mm-dd hh:mm:ss[.fff] '} such...

Use ODBC Standard

For example, now it's 23:11:00, 21 May 2008 is:

{ts '2008-05-21 23:11:00'}

Let's a query:

CREATE TABLE mydata (

type varchar(30),

day datetime

)

INSERT INTO mydata VALUES...