How do I form an SQL query to show entire column of dates with modified values?
Asuming the column has a datetime type, simply:

SELECT PurchaseDate + INTERVAL 5 DAY FROM


If it was a string type, you would have to parse it first.