[GitHub] [shardingsphere] RaigorJiang commented on issue #24398: Support parsing more functions SQL

[via GitHub]

RaigorJiang commented on issue #24398:
URL: 
https://github.com/apache/shardingsphere/issues/24398#issuecomment-1455932856

   Hi @kanha-gupta ,
   Thanks for your contribution!
   
   I would like to illustrate with the `EXTRACT` function as an example:
   1. Now SS can support the parsing of the following statements:
   ```
   SELECT EXTRACT(YEAR FROM '2019-07-02');
   ```
   <img width="932" alt="image" 
src="https://user-images.githubusercontent.com/5668787/223093913-405793a7-e498-42a0-92c9-93a969a9a8a7.png";>
   
   
   2. However, the following statement cannot be parsed
   ```
   SELECT EXTRACT(DAY_MINUTE FROM '2019-07-02 01:02:03');
   ```
   <img width="1210" alt="image" 
src="https://user-images.githubusercontent.com/5668787/223093969-8d988ab9-9ac8-4e09-913d-1aaa9cab111e.png";>
   
   Therefore, we need to optimize and check it.
   
   


-- 
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: notifications-unsubscr...@shardingsphere.apache.org

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