Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
how to select first 15 days and last 15 days of every month
krunal pande
Nov 7 2017 3:48 AM
150
Reply
Hi team,
how to select first 15 days and last 15 days of every month of the year dynamically in sql server.
e.g
DECLARE @Month INTEGER
DECLARE @Year INTEGER
declare @midofmonth DATETIME
DECLARE @FirstDayOfMonth DATETIME
DECLARE @LastDayOfMonth DATETIME
DECLARE @16DayOfMonth DATETIME
DECLARE @Date1 datetime
SET @Year = YEAR(GETDATE())
SET @FirstDayOfMonth = dateadd(month, @month - 1, dateadd(year, @year - 1900, 0))
SET @Month = month(@FirstDayOfMonth)
SET @LastDayOfMonth = dateadd(month, @month, dateadd(year, @year - 1900, -1))
set @midofmonth=dateadd(month, 7, dateadd(year, @year - 1900, -17))
set @16DayOfMonth=Dateadd(d,16-DATEPART(d,getdate()),GETDATE())
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Start Index of In SQL
sql inner join query with specifc condition column