Tag: mysql extract date from timestamp

MySQL EXTRACT Function

Example

Extract the month from a date:

SELECT EXTRACT(MONTH FROM "2017-06-15");

Definition and Usage

The EXTRACT() function extracts a part from a given date. Continue reading MySQL EXTRACT Function