Converting a date

Last modified

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]
Page statistics
227 view(s) and 4 edit(s)
Social share
Share this page?

Tags

CCH Insolvency

Comments

Attachments

 

 | Cookie Policy | Copyright | Privacy Policy Terms of Use | Contact Us |