[BUG] str_to_date does not work with two-digits year

[LantaoJin]

What is the bug?
str_to_date function in https://opensearch.org/docs/latest/search-plugins/sql/functions/#date-and-time does not work with two-digits year (RFC 822 date-time formatted).

How can one reproduce the bug?
Steps to reproduce the behavior:
Make a similar query

SELECT str_to_date('03-Jan-24', '%d-%b-%y');

returns
0024-01-03 00:00:00

What is the expected behavior?
Return 2024-01-03 00:00:00

What is your host/environment?

• Version: OpenSearch 2.14
• Plugins: SQL

Do you have any screenshots?
If applicable, add screenshots to help explain your problem.

Do you have any additional context?
Add any other context about the problem.

[dblock]

[Catch All Triage - Attendees 1, 2, 3, 4, 5]