yaooqinn commented on issue #26418: [SPARK-29783][SQL] Support SQL Standard output style for interval type URL: https://github.com/apache/spark/pull/26418#issuecomment-550842512 ## 1. vertica https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/DataTypes/Date-Time/DisplayingOrOmittingIntervalUnitsInOutput.htm?tocpath=SQL%20Reference%20Manual%7CSQL%20Data%20Types%7CDate%2FTime%20Data%20Types%7CINTERVAL%7C_____1 > If DATESTYLE is set to SQL, interval unit display always conforms to the SQL:2008 standard, which omits interval unit display. If DATESTYLE is set to ISO, you can use SET INTERVALSTYLE to omit or display interval unit display. ## 2. mysql MySQL seems to have intervals but not interval types, using time and year as an alternative. https://dev.mysql.com/doc/refman/8.0/en/year.html https://dev.mysql.com/doc/refman/8.0/en/time.html ## 3. Postgres https://www.postgresql.org/docs/9.0/datatype-datetime.html#DATATYPE-INTERVAL-OUTPUT Pg has 4 output styles for intervals. sql_standard, postgres, postgres_verbose, and iso_8601 @cloud-fan Currently I have checked for these dbs. thanks
---------------------------------------------------------------- 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]
