[CBRD-25302] Strengthens checks on date_lang_string_literal in functions such as TO_DATE()

[CBRD-25302] Strengthens checks on date_lang_string_literal in functions such as TO_DATE() #9934