Most databases offer you a function to retrieve a date in a specific format, independently of locale settings.

Instead of trying to parse all possible output formats, use that function instead.

(IIRC Oracle lets you control the format with an environment variable - that's another direction worth exploring. But it's all futile speculation unless you tell us what DB system you're using).