title: sqlalchemy date type in 0.6 migration using mssql
body: <p>I'm connection to mssql server through pyodbc, via FreeTDS odbc driver, on linux ubuntu 10.04.</p>
  
  <p>Sqlalchemy 0.5 uses <code>DATETIME</code> for <code>sqlalchemy.Date()</code> fields.</p>
  
  <p>Now Sqlalchemy 0.6 uses <code>DATE</code>, but sql server 2000 doesn't have a <code>DATE</code> type. How can I make <code>DATETIME</code> be the default for <code>sqlalchemy.Date()</code> on sqlalchemy 0.6 <code>mssql+pyodbc</code> dialect?</p>
  
  <p>I'd like to keep it as clean as possible.</p>
  
  <p>Here's code to reproduce the issue:</p>
  
  <pre><code>import sqlalchemy
  from sqlalchemy import Table, Column, MetaData, Date, Integer, create_engine
  
  engine = create_engine(
      'mssql+pyodbc://sa:sa@myserver/mydb?driver=FreeTDS')
  
  m = MetaData(bind=engine)
  
  tb = sqlalchemy.Table('test_date', m, 
      Column('id', Integer, primary_key=True),
      Column('dt', Date())
  )
  tb.create()
  </code></pre>
  
  <p>And here is the traceback I'm getting:</p>
  
  <pre><code>Traceback (most recent call last):
    File "/tmp/teste.py", line 15, in &lt;module&gt;
      tb.create()
    File "/home/nosklo/.local/lib/python2.6/site-packages/sqlalchemy/schema.py", line 428, in create
      bind.create(self, checkfirst=checkfirst)
    File "/home/nosklo/.local/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1647, in create
      connection=connection, **kwargs)
    File "/home/nosklo/.local/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1682, in _run_visitor
      **kwargs).traverse_single(element)
    File "/home/nosklo/.local/lib/python2.6/site-packages/sqlalchemy/sql/visitors.py", line 77, in traverse_single
      return meth(obj, **kw)
    File "/home/nosklo/.local/lib/python2.6/site-packages/sqlalchemy/engine/ddl.py", line 58, in visit_table
      self.connection.execute(schema.CreateTable(table))
    File "/home/nosklo/.local/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1157, in execute
      params)
    File "/home/nosklo/.local/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1210, in _execute_ddl
      return self.__execute_context(context)
    File "/home/nosklo/.local/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context
      context.parameters[0], context=context)
    File "/home/nosklo/.local/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute
      context)
    File "/home/nosklo/.local/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute
      context)
    File "/home/nosklo/.local/lib/python2.6/site-packages/sqlalchemy/engine/default.py", line 277, in do_execute
      cursor.execute(statement, parameters)
  sqlalchemy.exc.ProgrammingError: (ProgrammingError) 
  ('42000', '[42000] [FreeTDS][SQL Server]Column or parameter #2: 
  Cannot find data type DATE. (2715) 
  (SQLExecDirectW)') 
  '\nCREATE TABLE test_date (\n\tid INTEGER NOT NULL IDENTITY(1,1), 
  \n\tdt DATE NULL, \n\tPRIMARY KEY (id)\n)\n\n' ()
  </code></pre>