sql date greater than current date code example

Example 1: where date major today mysql

SELECT * FROM users WHERE created >= CURRENT_TIMESTAMP;

Example 2: mssql check if date is greater than today

WHERE YourDateValue >= DATEADD(MONTH, 1, GETDATE())