I Need Help Asap!!!! Please!!!!

[OrangePooh]

HELP ME PLEASE!!!!

I am just learning SQL and need to create a field called EVALDATE. This field should = HIREDATE + 3 months. How do I make the SQL statement?????? I hope someone out there can help.

THX

[bastien]

whats the db?

[kevinc]

Your question is rather vague. Are you wanting to do this in actual SQL, or PHP? It's pretty simple in PHP, have a look at the mktime function, you can perform mathematical functions on dates.

If you're wanting to do it in plain SQL, I'm not sure how to do that. I don't think it's possible in mySQL, I'm presuming you'd need stored procedure support, which isn't available in a stable release of mySQL yet. (Someone please correct me if I'm wrong here.)

Kevin.

[OrangePooh]

I am working with ADP ReportSmith, Kev. I would like to use SQL to write the script.

Thx for your quick response. I am under the gun.

BTW, RAT is the other white meat.

[bastien]

pooh, what is the db...each db may and can handle dates differently...what is the db you are using?

kev...it can be done in sql but is usually db dependant due to date handling

ex... oracle 9i has the add_months function

select add_months (date, 6) from mytable

would add 6 months to the current date...

mysql has the date_add function

SELECT DATE_ADD('1998-01-30', INTERVAL 1 MONTH);
-> 1998-02-28

[russellpehrson]

You do not need to store the evaulation date because you already have the hire date. You can then run a quarry in sql to find all employee that fall between a certian date or first add the amout of time needed first.
Here is the code for some thing similar it produces a list from our client list

SELECT Client.CourtDate, (Client.CourtDate+90) AS Ninety
FROM Client;

hopes this works for ya if not I will check back in a little bit to see