Converting a date

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]

Related