[ 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)