Documentation Home
MySQL 5.5 Reference Manual
Related Documentation Download this Manual Excerpts from this Manual

MySQL 5.5 Reference Manual  /  ...  /  Fractional Seconds in Time Values

11.3.6 Fractional Seconds in Time Values

A trailing fractional seconds part is permissible for temporal values in contexts such as literal values, and in the arguments to or return values from some temporal functions. Example:

mysql> SELECT MICROSECOND('2010-12-10 14:12:09.019473');
| MICROSECOND('2010-12-10 14:12:09.019473') |
|                                     19473 |

However, when MySQL stores a value into a column of any temporal data type, it discards any fractional part and does not store it.

User Comments
Sign Up Login You must be logged in to post a comment.