Skip to main content

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

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


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 !


Reply