Home » Developer & Programmer » Forms » question
question [message #81101] Tue, 07 January 2003 04:52 Go to next message
Yasser
Messages: 9
Registered: November 1998
Junior Member
HI;
HOW CAN I GET THE DIFERENCE BETWEN TO DATES IN DAYS?

THANK YOU FOR HELP.

Report message to a moderator

Re: question [message #81102 is a reply to message #81101] Tue, 07 January 2003 05:12 Go to previous message
Subhash
Messages: 105
Registered: October 2001
Senior Member
select to_date('31122002','ddmmrrrr') - to_date('01122002','ddmmrrrr') from dual ;

This will give you the number of days between these days.. 30

Regards
Subhash

Report message to a moderator

Previous Topic: Load data from text file to oracle database
Next Topic: QUESTION
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 19:37:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.