What SQL command(s) would you use to add the date on which an employee was hired to
Question:
What SQL command(s) would you use to add the date on which an employee was hired to the EMPLOYEE table represented in Figure? Name this new attribute Employment_ Date. Assume that the employees were hired on the following dates, using a year- month- day format as YYYYMMDD:
- Carl Elks 20000522
- Janet Robins 20010103
- Greg Kinman 19970825
- Christy Bazie 20040801
- Elaine Kopp 20060912
- John Mast 19950709
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Accounting Information Systems
ISBN: 978-1133935940
10th edition
Authors: Ulric J. Gelinas, Richard B. Dull
Question Posted: