OraFAQ Forum: SQL & PL/SQL » Subtract dates

Home » SQL & PL/SQL » SQL & PL/SQL » Subtract dates (Oracle SQL Developer 3.0.04)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Subtract dates [message #570648]

Tue, 13 November 2012 10:57

kestram
Messages: 2
Registered: November 2012

Junior Member

Hello,

New to using Oracle and SQL Developer. I am trying to subtract a maximum date from today and adding back 1 to get a field named daysSinceLastActivity....

Syntax I am trying is (date()-max(activity_date))+1 as daysSinceLastActivity

I keep getting a error message of missing expression. After googling, I am not finding anything that is helping.

Obviously, I am doing something wrong, but I do not understand. This should be a simple calculation.

Any help would be appreciated. Thanks.

Report message to a moderator

Re: Subtract dates [message #570649 is a reply to message #570648]

Tue, 13 November 2012 11:05

BlackSwan
Messages: 20106
Registered: January 2009

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>Syntax I am trying is (date()-max(activity_date))+1 as daysSinceLastActivity

Oracle does not have a "DATE()" function
try as below

sysdate-max(activity_date))+1 as daysSinceLastActivity

Report message to a moderator