Skip to content

Glossary: SQL Beyond the Basics

strftime

Also written: strftime()

A SQLite function that picks parts out of a date using % codes, such as strftime('%Y-%m', order_date) for the year and month. It is handy for monthly grouping.

Where the book teaches it

Related terms

date()julianday