Nikita Pande created PHOENIX-7205:
-------------------------------------
Summary: 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
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)
