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,
Solved! Go to Solution.
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 !