Fractional seconds missing for MySQL datatypes DATETIME and TIMESTAMP

[Former user]

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.

[Former user]

Patch adding support for fractional seconds for the MySQL DATETIME and TIMESTAMP

[Mike Bayer]

looks good I'll try to get to this soon. have some backups of pullreqs right now.

[Mike Bayer]

re-uploading attachment

[Mike Bayer]

dd6884eafaaf5082b2050e52715b363b54e7c561 0.8

a552606091bf84579751cd80ca458a0483b2b96a 0.9

thanks for the patch !

[Geert Vanderkelen]

Just a note claiming this bug report as my own, not 'Anonymous' :)

Thanks for fixing it!