Reporting with SQL
Date and Time Functions
How to only take the moth and day?
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
Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.