I’m trying to compare two dates without the year, only the day and the month (DD/MM) when for example 30/04 < 02/05. I want to be able to say wether a date is previous or not to another date based only on the day and the month without paying attention to the year. I tried to use FORMAT_DATE(“%d/%m”, DATE(“2021-04-30”)) <=
Tag: comparison
mysql compare specific date
I have a table which contains a varchar field containing date like ’15 May 2015 – 03:10 am’ I have to compare all date in this table with the current date to retrieve row which are next the current …