i have a query where i want to update the value based on orders made from a certain date
all the matters is just the month.

Update discount
set discount = 10
where pubdate = 'MAY';

ive tried a few date formats but i haven't found a clear way just to update the value based on month alone