Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
New feature: Microseconds in DATE/TIME values
+1 Vote Up -0 Vote Down

MariaDB 5.3 and up and MySQL 5.6 RC introduced real support for milliseconds:
https://kb.askmonty.org/en/microseconds-in-mariadb/
http://dev.mysql.com/doc/refman/5.6/en/fractional-seconds.html

HeidiSQL now lets you define a LENGTH/SET value for data types which allow a microsecond precision (0-6, where 0 is the default). Also, when editing such TIME, TIMESTAMP or DATETIME values in a grid, HeidiSQL lets you press arrow up/down to increase/decrease the microseconds part of the underlying value. Thanks to rjgebis for the report and documentation links.

Votes:

You must be logged in with a MySQL account to vote on Planet MySQL entries. More information on PlanetMySQL voting.

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

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.