<div>
This should do the trick:<br />

<pre><code id="code-213545">-- as datetime
SELECT DATEADD(mm, 1, DATEDIFF(dd, 0, GETDATE()) - DAY(GETDATE()) + 1) 
-- shortened string in format requested
SELECT CONVERT(VARCHAR(10), DATEADD(mm, 1, DATEDIFF(dd, 0, GETDATE()) - DAY(GETDATE()) + 1), 120)
</code></pre>
</div>


This should do the trick:


-- as datetime
SELECT DATEADD(mm, 1, DATEDIFF(dd, 0, GETDATE()) - DAY(GETDATE()) + 1) 
-- shortened string in format requested
SELECT CONVERT(VARCHAR(10), DATEADD(mm, 1, DATEDIFF(dd, 0, GETDATE()) - DAY(GETDATE()) + 1), 120)


<div>
sorry what about last day of next month??
</div>


sorry what about last day of next month??

<div>
<div class="content wysiwyg-content">
How do i write a sql to get the first day of next month?<br />
<br />
I need the anser to be in this format: '2009-01-01'
</div>
</div>


How do i write a sql to get the first day of next month?

I need the anser to be in this format: '2009-01-01'

First day of next month

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.