Table of contents
Overview
Explains what the feature is or what its benefits are to the user or customer.
Converting a date
The following listing turns a date in the format “dd/mm/yyyy” into “dd mm yy” to be formatted for certain fields, for example, a postal redirection form:
INSERT INTO @Data SELECT 'Todays_Date', REPLACE(CONVERT(VARCHAR(8), GETDATE(), 3), '/', ' ') AS [DD MM YY]
Comments