relative to the time the search is executed:sql>SELECT purchase_date FROM Purchases Use the "CONVERT" statement to get a date object and convert it into a string of characters:sql>SELECT purchase ...