He will resign two months later is perfectly grammatical and idiomatic, but means "later than the (future or possible) events I am talking ... ... <看更多>

You can use built-in INTERVAL instruction. Check how this works: SELECT CURRENT_DATE - INTERVAL '3 months'. and you can rewrite your SQL to: ... <看更多>