date-functions

SQLite’da sanalar matn sifatida saqlanadi: '2026-10-01' yoki '2026-10-01 14:30:00'.

SELECT strftime('%Y', hired_at) AS year FROM employees;          -- yil
SELECT strftime('%Y-%m', created_at) AS month, SUM(amount)
FROM orders GROUP BY month;                                      -- oylik tushum
SELECT date('2026-10-01', '+7 days');                            -- sana arifmetikasi
SELECT julianday(end_date) - julianday(start_date) AS days FROM trips;   -- kunlar farqi

Diqqat

• strftime matn qaytaradi: son bilan solishtirsangiz CAST(strftime('%Y', d) AS INTEGER).
• 'YYYY-MM-DD' formatidagi sanalarni oddiy <, > bilan solishtirish mumkin.