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

Examples

String context

To return the current date and time as a string:


        
        
            
                
                
                    SELECT CURRENT_TIMESTAMP();
                
            
            +---------------------+
| CURRENT_TIMESTAMP() |
+---------------------+
| 2020-04-26 17:50:29 |
+---------------------+

Numeric context

To return the current date and time as a number:


        
        
            
                
                
                    SELECT CURRENT_TIMESTAMP() + 0;
                
            
            +-------------------------+
| CURRENT_TIMESTAMP() + 0 |
+-------------------------+
|          20200426175043 |
+-------------------------+

Fractional seconds

To return the current date and time with microseconds up to 6 digits:


        
        
            
                
                
                    SELECT CURRENT_TIMESTAMP(6);
                
            
            +----------------------------+
| CURRENT_TIMESTAMP(6)       |
+----------------------------+
| 2020-04-26 17:51:00.903064 |
+----------------------------+

We can see that microseconds (part after the .) is returned to 6 digits precision.

Published by Arthur Yanagisawa

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Ask a question or leave a feedback...

Official MySQL Documentation

https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_current-timestamp

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!