SELECT * FROM user_account WHERE last_login_date > NOW() - INTERVAL 30 DAY;
The interval_expression represents a temporal interval. Intervals have this syntax:
INTERVAL expr unit
expr represents a quantity.
unit represents the unit for interpreting the quantity; it is a specifier such as HOUR, DAY, or WEEK.
INTERVAL keyword and the unit specifier are not case sensitive.
Temporal arithmetic also can be performed in expressions using
INTERVAL together with the + or - operator.