Functions [message #111496] |
Wed, 16 March 2005 16:53 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
gicone34
Messages: 1 Registered: March 2005
|
Junior Member |
|
|
What function will return Number of days for Time In Job for an employee. What if the employee had a promotion/demotion? I need to show both numbers in each Job for that period of time.
All I have is SYSDATE, SAL_CHG_DATE AND HIRE_DATE.
I use Discoverer 3.1
Thank you.
|
|
|
Re: Functions [message #112562 is a reply to message #111496] |
Sun, 27 March 2005 16:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
del_sandy
Messages: 22 Registered: February 2005 Location: Delhi
|
Junior Member |
![del_sandy2004](/forum/theme/orafaq/images/yahoo.png)
|
|
select (to_number(to_char(sysdate,'J'))-to_number(to_char(join_date,'J'))) as diff from dual;
Try this perhaps it will work..
Cheers
Sandy
|
|
|