Converting a date

Last updated:

    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:

    File:test/insolvency/230_21+PDF+templates/090_Additional+Steps/060_Convert+a+date/PDF_ConvertDate.png

    INSERT INTO @Data
    SELECT 'Todays_Date', REPLACE(CONVERT(VARCHAR(8), GETDATE(), 3), '/', ' ') AS [DD MM YY]