psukys opened a new issue, #1861:
URL: https://github.com/apache/datafusion-sqlparser-rs/issues/1861

   For Snowflake time formats support precision parameter ([from Snowflake 
documentation](https://docs.snowflake.com/en/sql-reference/data-types-datetime#timestamp)):
   > All timestamp variations, as well as the TIMESTAMP alias, support an 
optional precision parameter for fractional seconds (for example, 
TIMESTAMP(3)). Timestamp precision can range from 0 (seconds) to 9 
(nanoseconds). The default precision is 9.
   
   Note: this comes from using Python wrapper sqloxide
   
   Query that fails:
   ```sql
   create table hello(test timestamp_ntz(6))
   ```
   
   Error:
   ```
   sql parser error: Expected: ',' or ')' after column definition, found: ( at 
Line: 1, Column: 38
   ```
   
   removing precision from `timestamp_ntz` passes through
   
   Unfortunately I cannot directly link which version (not visible 
throughintroduced this regression, but it seems to be recent


-- 
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: github-unsubscr...@datafusion.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org

Reply via email to