How to use DATEADD in MySQL?

you can use DATE_SUB(CURDATE(), INTERVAL 30 minute)

DateAdd is missspelled: It must be DATE_ADD (with underscore). See the documentation

The MySQL syntax is:

WHERE ad_view_time >= now() - interval 30 minute