THE WORLD'S LARGEST WEB DEVELOPER SITE

MySQL TIMESTAMP() Function

❮ MySQL Functions

Example

Return a datetime value based on the arguments:

SELECT TIMESTAMP("2017-07-23",  "13:10:11");
Try it Yourself »

Definition and Usage

The TIMESTAMP() function returns a datetime value based on a date or datetime value.

Note: If there are specified two arguments with this function, it first adds the second argument to the first, and then returns a datetime value.

Syntax

TIMESTAMP(expression, time)

Parameter Values

Parameter Description
expression Required. A date or datetime value
time Optional. A time value to add to expression

Technical Details

Works in: From MySQL 4.0

More Examples

Example

Return a datetime value based on the arguments:

SELECT TIMESTAMP("2017-07-23");
Try it Yourself »

❮ MySQL Functions