MySQL LOCALTIMESTAMP() Function
Clash Royale CLAN TAG#URR8PPP
googletag.cmd.push(function() googletag.display('div-gpt-ad-1422003450156-2'); );
MySQL LOCALTIMESTAMP() Function
❮ MySQL Functions
Example
Return current date and time:
SELECT
LOCALTIMESTAMP();
Try it Yourself »
Definition and Usage
The LOCALTIMESTAMP() function returns the current date and time.
Note: The date and time is returned as "YYYY-MM-DD HH-MM-SS"
(string) or as YYYYMMDDHHMMSS.uuuuuu (numeric).
Syntax
LOCALTIME()
Technical Details
Works in: | From MySQL 4.0 |
---|
More Examples
Example
Return current date and time + 1:
SELECT
LOCALTIMESTAMP() + 1;
Try it Yourself »
❮ MySQL Functions