MariaDB: CURRENT_TIMESTAMP Function
This MariaDB tutorial explains how to use the MariaDB CURRENT_TIMESTAMP function with syntax and examples.
Description
The MariaDB CURRENT_TIMESTAMP function returns the current date and time.
Syntax
The syntax for the CURRENT_TIMESTAMP function in MariaDB is:
CURRENT_TIMESTAMP( )
Parameters or Arguments
There are no parameters or arguments for the CURRENT_TIMESTAMP function.
Note
- The CURRENT_TIMESTAMP function will return the current date as a 'YYYY-MM-DD HH:MM:SS' format, if used in a string context.
- The CURRENT_TIMESTAMP function will return the current date as a YYYYMMDDHHMMSS format, if used in a numeric context.
- The CURRENT_TIMESTAMP, LOCALTIME, and LOCALTIMESTAMP functions are synonyms for the NOW function.
Applies To
The CURRENT_TIMESTAMP function can be used in the following versions of MariaDB:
- MariaDB 10
Example
Let's look at some MariaDB CURRENT_TIMESTAMP function examples and explore how to use the CURRENT_TIMESTAMP function in MariaDB.
For example:
SELECT CURRENT_TIMESTAMP(); Result: '2014-05-18 10:41:33' SELECT CURRENT_TIMESTAMP() + 0; Result: 20140518104133 SELECT CURRENT_TIMESTAMP() + 1; Result: 20140518104134
Advertisements