MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: DATETIME does not keep fractional seconds (5.6.11)
Posted by: Peter Brawley
Date: December 29, 2013 02:03PM

To store fractional seconds you need ...

`datetime` datetime(6) DEFAULT CURRENT_TIMESTAMP(6),

See http://dev.mysql.com/doc/refman/5.6/en/fractional-seconds.html

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
[SOLVED] DATETIME does not keep fractional seconds (5.6.11)
P THE AWESOME
December 28, 2013 10:16PM
Re: DATETIME does not keep fractional seconds (5.6.11)
Peter Brawley
December 28, 2013 11:02PM
Re: DATETIME does not keep fractional seconds (5.6.11)
P THE AWESOME
December 29, 2013 11:20AM
Re: DATETIME does not keep fractional seconds (5.6.11)
Peter Brawley
December 29, 2013 02:03PM
Re: DATETIME does not keep fractional seconds (5.6.11)
P THE AWESOME
December 29, 2013 02:42PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.