[
https://issues.apache.org/jira/browse/DRILL-8340?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17621211#comment-17621211
]
ASF GitHub Bot commented on DRILL-8340:
---------------------------------------
cgivre opened a new pull request, #2689:
URL: https://github.com/apache/drill/pull/2689
# [DRILL-8340](https://issues.apache.org/jira/browse/DRILL-8340): Add
Additional Date Manipulation Functions (Part 1)
## Description
See below.
## Documentation
This PR adds several utility functions to facilitate working with dates and
times. These are modeled after the date/time functionality in MySQL.
Specifically this adds:
* `YEARWEEK(<date>)`: Returns an int of year week. IE (202002)
* `TIME_STAMP(<date string>)`: Converts most anything that looks like a
date string into a timestamp.
## Testing
Added unit tests.
> Add Additional Date Manipulation Functions (Part 1)
> ---------------------------------------------------
>
> Key: DRILL-8340
> URL: https://issues.apache.org/jira/browse/DRILL-8340
> Project: Apache Drill
> Issue Type: Improvement
> Components: Functions - Drill
> Affects Versions: 1.20.2
> Reporter: Charles Givre
> Assignee: Charles Givre
> Priority: Major
> Fix For: 2.0.0
>
>
> This PR adds several utility functions to facilitate working with dates and
> times. These are modeled after the date/time functionality in MySQL.
> Specifically this adds:
> * YEARWEEK(<date>): Returns an int of year week. IE (202002)
> * TIME_STAMP(<date string>): Converts most anything that looks like a date
> string into a timestamp.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
