MaxGekk commented on issue #25981: [SPARK-28420][SQL] Support the `INTERVAL` type in `date_part()` URL: https://github.com/apache/spark/pull/25981#issuecomment-537441643 I think we should fix calculations of seconds/milliseconds per months in Spark (here is the PR for that: https://github.com/apache/spark/pull/25998). And we shouldn't use wrong number `365.25` from PostgreSQL which is valid for the Julian calendar (https://en.wikipedia.org/wiki/Julian_calendar) but not in the proleptic Gregorian calender used in Spark (https://issues.apache.org/jira/browse/SPARK-26651).
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
