Latest date from date, month, year

Question

I have an SQLite DB with date, month, year fields in integers (I believe they should have used a date field but the choice wasn't mine). I would like to select the row whose date value is the latest. What is the best query to do that?

Answer 1

select * from your_table
order by year, month, `date` desc
limit 1