[Solved] Query Month & Date from multiple years
[Solved] Query Month & Date from multiple years
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.
Last edited by Dalke55 on Mon Jan 09, 2023 4:09 am, edited 1 time in total.
Apache OpenOffice 4.1.6 Windows 10
Re: Query Month & Date from multiple years
If you are using the default HSQLDB database engine, it has DAYOFMONTH() and MONTH() functions, so you could include
in you query
Code: Select all
WHERE DAYOFMONTH("DATE_COLUMN_NAME") = 11 AND MONTH("DATE_COLUMN_NAME") = 1
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Query Month & Date from multiple years
Thanks for the assistance!
Apache OpenOffice 4.1.6 Windows 10