[Solved] Query Month & Date from multiple years

[Dalke55]

I need to query Date Time stamp field for specific Day of a Month from multiple years in the same data set. Example January 11 from 2019, 2020, 2021, 2022. Thank you in advance.

[FJCC]

If you are using the default HSQLDB database engine, it has DAYOFMONTH() and MONTH() functions, so you could include

Code: Select all

WHERE DAYOFMONTH("DATE_COLUMN_NAME") = 11 AND MONTH("DATE_COLUMN_NAME") = 1

in you query

[Dalke55]

Thanks for the assistance!