This is a heavily interactive web application, and JavaScript is required. Simple HTML interfaces are possible, but that is not what this is.
Post
SQLDaily
sqldaily.bsky.social
did:plc:blmnab373idbogizdn742doc
You can subtract one year from a date in Oracle #SQL with either
ADD_MONTHS ( dt, -12 )
- INTERVAL '1' YEAR
But take care - these handle 29th Feb differently:
ADD_MONTHS => 29th Feb -> 28th Feb in previous year
INTERVAL => 29th Feb -> 29th Feb in previous year => error!
2025-10-06T11:03:04.661Z