Cast string to timestamp remaining work

[andygrove]

What is the problem the feature request solves?

https://github.com/apache/datafusion-comet/pull/335 added initial support for casting string to timestamp, but the feature is still disabled by default. There are some follow on items to implement before we can enable by default:

• Add support for 3 and 5 digit years
• Testing with try_cast and ANSI
• Add timezone support (see advice in https://github.com/apache/datafusion-comet/pull/335#issuecomment-2091930125)
• Passing all fuzz tests
• Updating compatibility guide

Describe the potential solution

No response

Additional context

No response

[kiran-4444]

I'd like to work on this

[sinhs]

I am interested in contributing to this repo. How to assign this issue to myself ?