Pages

How does one add a day/hour/minute/second to a date value in Oracle?

Oracle Date Manipulation with fraction

How to add day to oracle date

select sysdate+1 from dual;

How to add hour to oracle date

select sysdate+1/24 from dual;

How to add minute to oracle date

select sysdate +1/1440 from dual;

How to add second to oracle date

select sysdate + 1/86400 from dual;

ALL IN ONE QUERY

select sysdate, sysdate+1/24, sysdate +1/1440, sysdate + 1/86400 from dual;
DescriptionDate Expression
NowSYSDATE
Tomorow/ next daySYSDATE + 1
Seven days from nowSYSDATE + 7
One hour from nowSYSDATE + 1/24
Three hours from nowSYSDATE + 3/24
An half hour from nowSYSDATE + 1/48
10 minutes from nowSYSDATE + 10/1440
30 seconds from nowSYSDATE + 30/86400
Tomorrow at 12 midnightTRUNC(SYSDATE + 1)
Tomorrow at 8 AMTRUNC(SYSDATE + 1) + 8/24
Next Monday at 12:00 noonNEXT_DAY(TRUNC(SYSDATE), 'MONDAY') + 12/24
First day of the month at 12 midnightTRUNC(LAST_DAY(SYSDATE ) + 1)
The next Monday, Wednesday or Friday at 9 a.mTRUNC(LEAST(NEXT_DAY(sysdate,''MONDAY' ' ),NEXT_DAY(sysdate,''WEDNESDAY''), NEXT_DAY(sysdate,''FRIDAY'' ))) + (9/24)

No comments:

Post a Comment