SQL Quest › SQL Interview Questions › String Functions
Year Code from Order Date (SUBSTR)
A legacy report stores order_date as an ISO string ('YYYY-MM-DD'). Extract just the year portion using SUBSTR — no date functions.
Show order_id, order_date, and year_code (SUBSTR(order_date, 1, 4)). Order by order_id. Limit 15.
When a date is stored as a fixed-width string, SUBSTR is faster than strftime and works on any engine that has substring slicing. Use this trick whenever the data is ISO-formatted and the prefix is what you need.
Solve it in the browser editor →
Runs on SQLite in your browser, graded against the expected result, no signup. A wrong answer gets a diagnosis, not just "incorrect". Free accounts get 10 free challenge solves, and this can be one of them.
Schema
orders
| order_id | customer_id | product | category | quantity | price | total | order_date | country | status |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | Laptop Pro | Electronics | 1 | 1299.99 | 1299.99 | 2024-01-15 | USA | completed |
| 2 | 2 | Wireless Mouse | Electronics | 2 | 49.99 | 99.98 | 2024-01-16 | Canada | completed |
| 3 | 3 | Office Chair | Furniture | 1 | 349.99 | 349.99 | 2024-01-17 | USA | completed |
Expected output: year_code = '2024'
Hint
SELECT, SUBSTR, String Functions, and open the hint there if you stall.Concepts
SELECT SUBSTR String Functions
Practise the topic: SQL practice questions · String function practice
Read the concept: SQL cheat sheet
Related questions
Where would this cost you points in an interview?
Ten questions, no signup: a Skillmap across nine SQL skills and the one to fix first.
Take the readiness test