How to select oldest date from MySQL

select MyDate from MyTable order by MyDate asc limit 2

You can order by the date field in your database. For oldest:

SELECT * FROM table WHERE condition ORDER BY dateField ASC LIMIT 1

For two oldest:

SELECT * FROM table WHERE condition ORDER BY dateField ASC LIMIT 2

etc, etc, ...

Single oldest is easy:

SELECT MIN(datefield) FROM yourtable

Oldest n values requires a LIMIT query:

SELECT datefield FROM yourtable ORDER By datefield ASC LIMIT n