Date back in mysql

Navigation
0

Good morning everyone! how do I, in a query in mysql catch dynamically generate the date referring to 3 months ago?

    
asked by anonymous 28.08.2017 / 15:55

1 answer

0

You can use the Sysdate function next to the interval for example: 

SELECT (SYSDATE() - INTERVAL 3 MONTH) FROM DUAL

or leave the number of days fixed: 

SELECT (SYSDATE() - 90) FROM DUAL
    
29.08.2017 / 16:21
Graphics interface package Maven compilation error plugin