How to get the first day of preceding month

Question

Post reply

How to get the first day of preceding month

manibad

SSCommitted

Points: 1556
More actions
February 12, 2013 at 12:31 pm

#289269

I need to get the first day of the followingmonth.How is it possible.I am unable to find a way to proceed
i.e my output should be like this
Scenario 1:
Input-2012/01/29
Output-2012/02/01
Scenario 2:
Input-2012/12/29
output-2013/01/01
I need to accumlate both the scenarios in same coding
Please guide me in solving this.
Thanks in advance

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246961 More actions · Answer 1

I can't really see what this has to do with SSIS, but here's one way.

declare @MyDate datetime

set @MyDate = '2012-12-29'

select DATEADD(dd, - (DAY(DATEADD(mm, 1, @MyDate )) - 1), DATEADD(mm, 1, @MyDate ))

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Sachin4all Ten Centuries Points: 1249 More actions · Answer 2

Here is an example query to do it

Declare @day date

set @day = '2012/01/29'

select @day

Select DAY(@day) as Noofdays

SELECT DATEADD(mm,1,DATEADD(dd,-(DAY(@day)-1),@day)) AS Day

Select DATEADD(yy,1,DATEADD(dd,-(DAY(@day)-1),@day)) as Day

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Using T-SQL:

declare @MyDate datetime;

set @MyDate = '20121229';

select dateadd(mm, datediff(mm,cast('19000101' as datetime),@MyDate) + 1, cast('19000101' as datetime)), @MyDate;

manibad SSCommitted Points: 1556 More actions · Answer 4

I have to work on SSIS to get the first day of following month and the output should be as string value.

Input:getdate()

Output:Firstday of the following month

format of output is=yyyymmdd

Sorry for not providing the perfect information in the previous post.