easyAstro · date-time
Days remaining until subscription expiry
Using 2026-08-01 as "today", compute how many days remain until each subscription expires. A subscription that already expired should show a negative number.
Return customer, expiry_date, and days_remaining.
Schema
▸subscriptions
| id | INT |
| customer | TEXT |
| expiry_date | DATE |
Example input
▸subscriptions