I've found that this works on 9.2.0.1 and later -
YEAR:
select sysdate + interval '1' year from dual
--Which return current date plus one year
Sysdate =01/01/2018(dd/mm/yyyy) Output: 01/01/2019
MONTH:
select sysdate + interval '1' month from dual
--Which return current date plus one Month
Sysdate =01/01/2018(dd/mm/yyyy) Output: 01/02/2018
DAY:
select sysdate + interval '1' day from dual
--Which return current date plus one day
Sysdate =01/01/2018(dd/mm/yyyy) Output: 02/01/2018
Showing posts with label Date. Show all posts
Showing posts with label Date. Show all posts
02 August, 2019
27 February, 2011
Get All Friday Date of a Year in MS SQL
--Exec [dbo].getFriday '2011'
Create procedure [dbo].getFriday(@pYear nvarchar(50))
AS
BEGIN
DECLARE @FirstDay datetime
declare @intFlag int
set @FirstDay='01 Jan '+@pYear
set @intFlag=2
if datepart(dw,@FirstDay)=6 --For friday=6,Sunday=1....
print 'Friday: '+@FirstDay
WHILE (@intFlag<=365)
BEGIN
set @FirstDay=DATEADD(dd,1,@FirstDay)
set @intFlag = @intFlag + 1
if datepart(dw,@FirstDay)=6
print 'Friday: '+@FirstDay
END
END
Create procedure [dbo].getFriday(@pYear nvarchar(50))
AS
BEGIN
DECLARE @FirstDay datetime
declare @intFlag int
set @FirstDay='01 Jan '+@pYear
set @intFlag=2
if datepart(dw,@FirstDay)=6 --For friday=6,Sunday=1....
print 'Friday: '+@FirstDay
WHILE (@intFlag<=365)
BEGIN
set @FirstDay=DATEADD(dd,1,@FirstDay)
set @intFlag = @intFlag + 1
if datepart(dw,@FirstDay)=6
print 'Friday: '+@FirstDay
END
END
Subscribe to:
Posts (Atom)