Initializing SQL database...
Back to Questions
Date Function - Extract Year #30
easyExtract the year from hire_date for each employee. Work with date and time data using functions like DATE(), TIME(), DATETIME(). Use STRFTIME() to format dates or extract parts like year, month, day.
Practice with:
Database Schema
employees
Employee information
idnamehire_date
Expected Output
Click "Show" to see what the correct output should look like.Tip: Try solving it yourself first for better learning!
SQL Editor
Loading...
Press Ctrl+Enter to run query • Start typing for autocomplete