[Sqlalchemy-tickets] [sqlalchemy] #2941: Fractional seconds missing for MySQL datatypes DATETIME and TIMESTAMP

[sqlalchemy <mi...@zz...>]

#2941: Fractional seconds missing for MySQL datatypes DATETIME and TIMESTAMP
-------------------------------------+-------------------------------------
 Reporter:  geertjanvdk              |           Owner:
     Type:  enhancement              |          Status:  new
 Priority:  medium                   |       Milestone:
Component:  mysql                    |        Severity:  no triage selected
 Keywords:  mysql mysqlconnector     |  yet
  datetime timestamp fractional      |  Progress State:  awaiting triage
-------------------------------------+-------------------------------------
 SQLAlchemy added support for fractional seconds in v0.8, but MySQL 5.6
 also supports this for DATETIME and TIMESTAMP types.

 Thus, something like this works:

 {{{
  CREATE TABLE t1 (
    created DATETIME(6) CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6)
  )
 }}}

 Note that this works with the mysqlconnector dialect.
 Attaching a patch.

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2941>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python