TIMESTAMP

Generate a datetime value from the provided arguments.

SELECT TIMESTAMP(“2017-07-23”, “13:10:11”);

Definition and Usage

The TIMESTAMP() function produces a datetime value from a given date or datetime input.

Note: If two arguments are provided, the function first adds the second argument to the first and then returns a datetime value.

TIMESTAMP(expression, time)

Parameter	Description
expression	Required: A value representing a date or datetime.
time	Optional: A time value to be added to the expression.

Works in:

From MySQL version 4.0

Generate a datetime value using the provided arguments.

SELECT TIMESTAMP(“2017-07-23”);