Skip to content
Advertisement

SELECT timestamp MATCH DAY 25 or 26

I am trying to get all timestamps from the Database, that match the day of the month that are specifyed. All i have is the day numbers(25, 26, 27 ect.) and not a full date strings(25/12/2018, 26/12/2018 ect.)

Is there a way to do:

JavaScript

Or do I need this:

JavaScript

It will always be the current month and year, only the day changes.

Advertisement

Answer

Using the DAYOFMONTH() function would do this for you

JavaScript

And if you have more than one day to look for

JavaScript
User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement