Tag: mysql extract number from string

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