Search docs using month and day in birthday filed using elasticsearch SQL

i have a filed name birthday. which has date of birth in Date format.

now using Elasticsearch SQL query, I want get
"list all people who have birthdays in January"

how to get all people using whose birthday is in January.
birthday dates are:

  1. 02/04/1995
  2. 23/04/1991
  3. 21/09/1885

You can use the month functions in date/time functions.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.