| Functions [message #111496] |
Wed, 16 March 2005 16:53  |
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  |
del_sandy
Messages: 22
Registered: February 2005
Location: Delhi
|
Junior Member |
|
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
