Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.
COURSE of the MONTH
12 days, 5 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Get Year, Month, beginning of next month
Posted on 2015-02-13
I want to pass a string sample '02/01/2015' or any day of that month and get the following.
@enddate should return '03/01/2015' (the beginning of next month)
@month should return '02'
@year should return '2015'
@enddate should return '03/01/2015' (the beginning of next month)
@month should return '02'
@year should return '2015'
Declare @EndDate as varchar(12)
declare @month as varchar(2)
declare @year as varchar(4)
Set @EndDate = @startdate > should be '03/01/2015' (the first day of next month)
Set @Month = @startdate > should be '02'
Set @Year = @startdate > should be '2015'
select @enddate
select @month
select @year
select MONTH('02/01/2015') < how can I return '02' instead of '2'
select YEAR('02/01/2015') < this is ok '2015'
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
6-
3
9 Comments
Active today
Set @EndDate = DATEADD(dd, - (DAY(DATEADD(mm, 1, getdate() )) - 1), DATEADD(mm, 1, getdate() ))
Hi PorletPaul,
It is fine. I am just test a small tmp table.
How about Month something like this ?
'0' + convert(char(10), DATEPART(MM, @startdate)) > I want it to return 02 instead of 2
It is fine. I am just test a small tmp table.
How about Month something like this ?
'0' + convert(char(10), DATEPART(MM, @startdate)) > I want it to return 02 instead of 2
Active today
untested
declare @EndDate as varchar(12)
declare @month as varchar(2)
declare @year as varchar(4)
Set @EndDate = CONVERT(varchar(12), DATEADD(dd, - (DAY(DATEADD(mm, 1, getdate() )) - 1), DATEADD(mm, 1, getdate() )), 101)
Set @Month = CONVERT(varchar(2), getdate() , 101)
Set @Year = CONVERT(varchar(4), getdate() , 111)
select @enddate
select @month
select @year
The beginning of next month '03/01/2015', not the first day of the month that is passing.
Set @EndDate = DATEADD(dd, - (DAY(DATEADD(mm, 1, getdate() )) - 1), DATEADD(mm, 1, getdate() ))
Set @EndDate = DATEADD(dd, - (DAY(DATEADD(mm, 1, getdate() )) - 1), DATEADD(mm, 1, getdate() ))
Active today
?
it returns see COLUMN_0
@enddate should return '03/01/2015' (the beginning of next month)
it returns see COLUMN_0
| COLUMN_0 | COLUMN_1 | COLUMN_2 |
|------------|----------|----------|
| 03/01/2015 | 02 | 2015 |
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article explains how to reset the password of the sa account on a Microsoft SQL Server. The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses
Course of the Month12 days, 5 hours left to enroll
752 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.