Home » SQL & PL/SQL » SQL & PL/SQL » Re: Calculate days between dates.
Re: Calculate days between dates. [message #20200] Mon, 06 May 2002 11:47
madhu.motukuri
Messages: 3
Registered: May 2002
Junior Member
Hello,

If both the columns are datatype DATE, why don't you just subtract them .. like date2-date1 to get the number of days in between ..

I hope this helps

Thx
Madhu.Motukuri

Report message to a moderator

Previous Topic: query dates
Next Topic: ORA-04043: object SYS.dba_tables does not exist.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 15:55:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.