liukun4515 commented on issue #6876:
URL: 
https://github.com/apache/arrow-datafusion/issues/6876#issuecomment-1634041209

   
   > Upstream will, in the next release, support date subtraction returning a 
duration in addition to adding durations or intervals to dates. 
   
   What‘s the upstream? arrow-rs?
   
   >I think the semantics of adding plain integers to dates is suitably opaque 
that we probably won't support that upstream, but the approach of using a 
rewrite to convert to a duration makes a lot of sense
   
   I also think the semantics of adding plain integers to dates is not suitable 
for adding in the arrow-rs.
   
   The pg https://www.postgresql.org/docs/current/functions-datetime.html 
support the operation
   ```
   date + integer → date
   
   Add a number of days to a date
   
   date '2001-09-28' + 7 → 2001-10-05
   
   ```
   We can use the rewrite to support them.
   
   Thanks @tustvold 
   
   
   
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to