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 | LOCALTIME 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. fsp | number | optional

The fractional seconds precision, that is the number of digits to use to store microseconds.

This can take the range 0 - 6. Defaults to fsp=0.

Return value

Case	Return Value	Example
NOT used in numeric context	`LOCALTIME(~)`	`'YYYY-MM-DD hh:mm:ss'` (string)
Used in numeric context	`LOCALTIME(~) + 0`	`YYYYMMDDhhmmss` (number)

Examples

String context

To return the current time in the session time zone:


        
        
            
                
                
                    SELECT LOCALTIME();
                
            
            +---------------------+
| LOCALTIME()         |
+---------------------+
| 2020-04-16 16:01:50 |
+---------------------+

Numeric context

To return the current time in the session time zone as a number:


        
        
            
                
                
                    SELECT LOCALTIME() + 0;
                
            
            +-----------------+
| LOCALTIME() + 0 |
+-----------------+
|  20200416160236 |
+-----------------+

Fractional seconds

To specify the fractional seconds precision:


        
        
            
                
                
                    SELECT LOCALTIME(6);
                
            
            +----------------------------+
| LOCALTIME(6)               |
+----------------------------+
| 2020-04-16 16:03:21.814470 |
+----------------------------+