Riojan
|
| Posted: 04/12/2005, 6:30 AM |
|
I'm a newbie in both php and codecharge. I'm using PHP and Postgresql + Apache. I've a table that include the following fields:
emp_id, date_contract, category, duration.
Where emp_id is the employee internal code, date is the beggining date of the contract, category is the function of the employee (teacher degree1, teacher degree2, teacher degree3...), duration is the number of days of that contract. The emp_id+date are the primary key. This table represents the carreer evolution of each employee in the enterprise. How would i know (and implement in codecharge or php):
1) last category of each employee (the present one)
2) end date of the contract (date_contract + duration)
Thanks in advance for your attention
|
|
|
 |
Nicole
Posts: 586
|
| Posted: 04/13/2005, 1:56 AM |
|
Riojan,
I’m not an expert in PostgreSQL but I suppose that you can build queries using Postgre date/time functions which return data you mentioned
_________________
Regards,
Nicole |
 |
|
|
