News

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 ...