Display only the year value from each employee’s hire date.
Write queries for the following. (Use tables created in Chapter 4 Lab Activity.)
```
SQL> SELECT LName, FName, TO_CHAR(HireDate, 'YYYY')
2 FROM employee;
LNAME FNAME TO_C
--------------- --------------- ----
Smith John 1960
Houston Larry 1967
Roberts Sandi 1991
McCall Alex 1997
Dev Derek 1995
Shaw Jinku 2000
Garner Stanley 1996
Chen Sunny 1999
8 rows selected.
```
You might also like to view...
To add a new comment to a document, you click the New Comment button in the:
A) Comments group on the Review Tab. B) Review group on the Comments Tab. C) Add group on the Comments Tab. D) Comments group on the Add Tab.
Bonds are categorized as ________ securities because the company is indebted to the people who loan the company money through the purchase of bonds
Fill in the blank(s) with the appropriate word(s).