When I use Datevalue it does not seem to use my locale settings, rather it is hardcoded to the American MM/DD/YYYY.
I already reported this issue internally: CRI 33725859. Will update here once get the feedback.
Best Regards,Qiuyun Yu
I got the information from PG that
"This is a bug that will take some effort to address. We will add a back log item for it. "