 <p>If this is SQL Server, use <a href="http://msdn.microsoft.com/en-us/library/aa226054%28v=sql.80%29.aspx" rel="nofollow">CONVERT</a>:</p> <pre><code> SELECT CONVERT(varchar(10), DATEADD(Month,1,GETDATE()), 120) </code></pre> <p>If you need the day before that date, just use <code>DATEADD</code> again:</p> <pre><code>SELECT CONVERT(varchar(10), DATEADD(Day, -1, DATEADD(Month,1,GETDATE())), 120) </code></pre>