support CastTimeAsDuration in TiFlash

[windtalker]

Feature Request

Is your feature request related to a problem? Please describe:

Describe the feature you'd like:

Support CastTimeAsDuration in TiFlash
TiDB's implementation:
https://github.com/pingcap/tidb/blob/562bb9f9e2c194c3f398300d5e5e920965da9f47/expression/builtin_cast.go#L1454
Describe alternatives you've considered:

Teachability, Documentation, Adoption, Migration Strategy:

[AntiTopQuark]

Hi, has this job been done by someone?

I want to do this job. But I don't have much experience and I'm a little busy. I may do it for a long time. Is there a Deadline in this job?

[Willendless]

Hi, has this job been done by someone?

I want to do this job. But I don't have much experience and I'm a little busy. I may do it for a long time. Is there a Deadline in this job?

Hi, feel free to give it a try. There is no hard deadline for this task. I can assign this task to you :)

[Willendless]

/assign @AntiTopQuark

[AntiTopQuark]

/assign @AntiTopQuark

Thank you, I will try to do my best to do it well

[Willendless]

/label good first issue

[ti-chi-bot]

@Willendless: The label(s) good-first-issue cannot be applied. These labels are supported: duplicate, first-time-contributor, good first issue, help wanted, invalid, question, wontfix, make-local-great-again, needs-cherry-pick-release-3.1, needs-cherry-pick-release-4.0, needs-cherry-pick-release-5.0-rc, needs-cherry-pick-release-5.0, needs-cherry-pick-release-5.1, needs-cherry-pick-release-5.2, needs-cherry-pick-release-5.3, needs-cherry-pick-release-5.4, needs-cherry-pick-release-6.0, needs-cherry-pick-release-6.1, needs-rebase.

In response to this:

/label good-first-issue

Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the ti-community-infra/tichi repository.