[
https://issues.apache.org/jira/browse/PHOENIX-7205?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nikita Pande reassigned PHOENIX-7205:
-------------------------------------
Assignee: Nikita Pande
> Support DAYS operator as built in functions
> -------------------------------------------
>
> Key: PHOENIX-7205
> URL: https://issues.apache.org/jira/browse/PHOENIX-7205
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: Nikita Pande
> Assignee: Nikita Pande
> Priority: Major
>
> DAYS: [https://www.ibm.com/docs/en/db2-for-zos/12?topic=functions-days]
> {*}Description{*}: The DAYS function converts each date to a number (the
> number of days
> since '0001-01-01'), and subtracting these numbers gives the number of days
> between
> the two dates. o/p is *364* since 2022 is not a leap year
> {*}Example{*}:
> {code:java}
> SELECT (DAYS('2022-12-31') - DAYS('2022-01-01')) AS days_difference FROM
> sysibm.sysdummy1;
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
