and “SQL basics: Number data types,” which details using number data types. Data types that have values representing times or dates are referred to as datetimes. Each datetime data type has ...

The "101" in the last argument specifies the format of the return value – in this case, "mm/dd/yyyy":sql>SELECT purchase_date FROM Purchases WHERE(SELECT CONVERT(varchar, GETDATE() - 1 ...