chevron_left Date and Time

Method ADDDATE Method ADDTIME Method CONVERT_TZ Method CURDATE Method CURRENT_DATE Method CURRENT_TIME Method CURRENT_TIMESTAMP Method CURTIME Method DATE Method DATE_ADD Method DATE_FORMAT Method DATE_SUB Method DATEDIFF Method DAY Method DAYNAME Method DAYOFMONTH Method DAYOFWEEK Method DAYOFYEAR Method EXTRACT Method FROM_DAYS Method FROM_UNIXTIME Method GET_FORMAT Method HOUR Method LAST_DAY Method LOCALTIME Method LOCALTIMESTAMP Method MAKEDATE Method MAKETIME Method MICROSECOND Method MINUTE Method MONTH Method MONTHNAME Method NOW Method PERIOD_ADD Method PERIOD_DIFF Method QUARTER Method SEC_TO_TIME Method SECOND Method STR_TO_DATE Method SUBDATE Method SUBTIME Method SYSDATE Method TIME Method TIME_FORMAT Method TIME_TO_SEC Method TIMEDIFF Method TIMESTAMP Method TIMESTAMPADD Method TIMESTAMPDIFF Method TO_DAYS Method TO_SECONDS Method UNIX_TIMESTAMP Method UTC_DATE Method UTC_TIME Method UTC_TIMESTAMP Method WEEK Method WEEKDAY Method WEEKOFYEAR Method YEAR Method YEARWEEK

thumb_up

thumb_down

chat_bubble_outline
0
 auto_stories new 
settings

MySQL | MICROSECOND method

Database

chevron_right

MySQL

chevron_right

Documentation

chevron_right

Functions

chevron_right

Date and Time

schedule Jul 1, 2022

Last updated

local_offer MySQL

Parameters

1. expr | time/datetime

The time/datetime to retrieve the microseconds from.

Return value

The microseconds portion (0-999999) of the input time/datetime.

Examples

To return the microseconds from a time:


        
        
            
                
                
                    SELECT MICROSECOND('12:55:32.38572098');
                
            
            +----------------------------------+
| MICROSECOND('12:55:32.38572098') |
+----------------------------------+
|                           385721 |
+----------------------------------+

Note that the microseconds portion (often referred to as fractional seconds) is everything to the right of the .

To return microseconds from a datetime:


        
        
            
                
                
                    SELECT MICROSECOND('2020-04-16 18:05:55.223459');
                
            
            +-------------------------------------------+
| MICROSECOND('2020-04-16 18:05:55.223459') |
+-------------------------------------------+
|                                    223459 |
+-------------------------------------------+