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 |
+----------------------------+