Showing posts with label Date. Show all posts
Showing posts with label Date. Show all posts

02 August, 2019

Add year, Month and Day to date in Oracle

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

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