Skip to content

[Feature][SQL] SQL transform EXTRACT function support more field #9325

@Hisoka-X

Description

@Hisoka-X

Search before asking

  • I had searched in the feature and found no similar feature requirement.

Description

Currently, EXTRACT only supports several common fields:
YEAR
MONTH
DAY
HOUR
MINUTE
SECOND
MILLISECOND
DAYOFWEEK
DAYOFYEAR.
Refer https://seatunnel.apache.org/docs/2.3.10/transform-v2/sql-functions#extract
we need to support more fields, for example all fields in postgresql.
Please refer https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT

Usage Scenario

No response

Related issues

No response

Are you willing to submit a PR?

  • Yes I am willing to submit a PR!

Code of Conduct

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions