Home » RDBMS Server » Server Administration » find months between two date
find months between two date [message #60850] Wed, 10 March 2004 01:36 Go to next message
Anbu
Messages: 6
Registered: August 2000
Junior Member
Hai all,

I need a help for the following query

select date1,date2
from dual;

i want difference for the above two date but result should be dd/mm/yyyy format

for example

date1 : 08/03/2004
date2 : 09/03/2004
result: 01/00/2000

Regards
Anbu.

Report message to a moderator

Re: find months between two date [message #60854 is a reply to message #60850] Wed, 10 March 2004 06:50 Go to previous message
saj
Messages: 8
Registered: January 1999
Junior Member
Your question is not clear..
How do u get the "result: 01/00/2000" ?

Report message to a moderator

Previous Topic: number of allocated extents of a tablespace
Next Topic: Database Recovery
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jan 07 23:07:53 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.