Home » RDBMS Server » Server Administration » Re: Query its urgent
Re: Query its urgent [message #372538] Tue, 20 February 2001 21:44
amarpatgiri
Messages: 11
Registered: December 2000
Junior Member
Use something like this:

select name,trunc(months_between(sysdate,jdate)/12,0) Year,
trunc(months_between(sysdate,jdate)-trunc(months_between(sysdate,jdate)/12,0)*12,0) Mon,
from emp

Change column names as necessary please.

-amar

Report message to a moderator

Previous Topic: sequence number
Next Topic: utl_file can't be used
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 18 08:09:09 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.