Converting ISO date to European format date with leading zeros

Question

Hi everyone,An application is sending me a date in ISO format (2022-02-13) and I want to convert it in the european date format without dropping the day and month leading zeros ( = 13/02/2022). I managed to convert from ISO to European but the leading zeros are dropped.If I use the DATETIME_FORMAT with the 'L' specifier, the leading zeros are back but the format reverse to the american format ( = MM/DD/YYYY).Is there a way to keep both the european format and the leading month and day zeros ?Thanks in advance for your help, Gilles

TheTimeSavingCo · Accepted Answer

Hm, may I know what issues you faced using DATETIME_FORMAT with 'DD/MM/YYYY'?DATETIME_FORMAT(  Date,  'DD/MM/YYYY')Apologies if I've misunderstood something

JaponaisNaturel · Answer

Hm, may I know what issues you faced using DATETIME_FORMAT with 'DD/MM/YYYY'?

DATETIME_FORMAT(
  Date,
  'DD/MM/YYYY'
)

Apologies if I've misunderstood something

Thanks for your reply Adam ! You did not misunderstood anything !

What you proposed worked perfectly !

I don't know what I did wrong when I tried DATETIME_FORMAT yesterday but that wasn't what I got at the time.

Anyway, thanks again for your help !

Problem solved !

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded