Make DATEDIFF of Redshift behave as TIMESTAMPDIFF of MySQL
<p>In <code>MYSQL</code>, <code>TIMESTAMPDIFF(MONTH, '2016-01-31', '2016-02-01')</code> returns <code>0</code>.</p>

<p>In <code>Redshift</code>, <code>DATEDIFF(MONTH, '2016-01-31', '2016-02-01')</code> returns <code>1</code>.</p>

<p>How do I make the <code>DATEDIFF(MONTH, '2016-01-31', '2016-02-01')</code> in <code>Redshift</code> to return <code>0</code>?</p>

<p>Currently I am using <code>DATEDIFF(DAY, '2016-01-31', '2016-02-01')/30</code>. But this is not good enough as some months have 28-31 days.</p>