Databases Reporting with SQL Date and Time Functions Practice Session

1 Answer

KRIS NIKOLAISEN
KRIS NIKOLAISEN
54,370 Points

Here are the date and time functions for SQLite - the database used in SQL playground. To extract the month and day you can use the strftime function. For example:

SELECT strftime('%m %d', loaned_on) as month_and_day FROM loans