Comparing Extract Functions

Choose the right way to extract date parts in SQL — YEAR, MONTH and DAY versus DATEPART and DATENAME, DATETRUNC versus extraction, SQLite equivalents, return types, performance and a decision tree.