waitingkuo commented on issue #1992: URL: https://github.com/apache/arrow-datafusion/issues/1992#issuecomment-1263633146
from postgresql's doc https://www.postgresql.org/docs/current/functions-datetime.html The extract function is primarily intended for computational processing. For formatting date/time values for display, see [Section 9.8](https://www.postgresql.org/docs/current/functions-formatting.html). The date_part function is modeled on the traditional Ingres equivalent to the SQL-standard function extract: `date_part('field', source)` Note that here the field parameter needs to be a string value, not a name. The valid field names for date_part are the same as for extract. For historical reasons, the date_part function returns values of type double precision. This can result in a loss of precision in certain uses. Using extract is recommended instead. -- 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]
