I need to send birthday wishes to users in my application.
I have a table "userdetails" with the column "dob". I need a query to retrieve users having a date of birth matching today's date.
For example, if a user has a "dob" value "1991-01-21 00:00:00", I have to send a birthday email to the user.
const users = await userdetails.find({
where: {
dob: " " // not sure what goes in there
},
});
Here, I am not sure what I can put in the where field to match my query.
If column type is date, the code will probably be like this:
where: {
dob: new Date().toISOString().slice(0,10), // '2022-01-25'
},