You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "zclllyybb (via GitHub)" <gi...@apache.org> on 2024/07/24 10:49:03 UTC

[PR] [branch-2.1](function) fix FE impl of some time functions (#37746) [doris]

zclllyybb opened a new pull request, #38316:
URL: https://github.com/apache/doris/pull/38316

   pick https://github.com/apache/doris/pull/37746
   
   before:
   ```sql
   mysql> select date_ceil("2020-12-12 12:12:12.123", interval 2 second);
   +-----------------------+
   | '2020-12-12 12:12:12' |
   +-----------------------+
   | 2020-12-12 12:12:12   |
   +-----------------------+
   1 row in set (0.10 sec)
   
   mysql> select CONVERT_TZ('9999-12-31 23:59:59.999999', 'Pacific/Galapagos', 'Pacific/Galapagos');
   +------+
   | NULL |
   +------+
   | NULL |
   +------+
   1 row in set (0.09 sec)
   
   mysql [(none)]>select CONVERT_TZ('9999-12-31 23:59:59.999999', 'Pacific/Galapagos', 'Pacific/GalapaGoS');
   +-----------------------------------------------------------------------------------------------------------+
   | convert_tz(cast('9999-12-31 23:59:59.999999' as DATETIMEV2(6)), 'Pacific/Galapagos', 'Pacific/GalapaGoS') |
   +-----------------------------------------------------------------------------------------------------------+
   | 9999-12-31 23:59:59.999999                                                                                |
   +-----------------------------------------------------------------------------------------------------------+
   1 row in set (0.08 sec) --- gone to BE
   ```
   after:
   ```sql
   mysql> select date_ceil("2020-12-12 12:12:12.123", interval 2 second);
   +------------------------------+
   | '2020-12-12 12:12:14.000000' |
   +------------------------------+
   | 2020-12-12 12:12:14          |
   +------------------------------+
   1 row in set (0.11 sec)
   
   mysql> select CONVERT_TZ('9999-12-31 23:59:59.999999', 'Pacific/Galapagos', 'Pacific/Galapagos');
   +-----------------------------------------------------------------------------------------------------------+
   | convert_tz(cast('9999-12-31 23:59:59.999999' as DATETIMEV2(6)), 'Pacific/Galapagos', 'Pacific/Galapagos') |
   +-----------------------------------------------------------------------------------------------------------+
   | 9999-12-31 23:59:59.999999                                                                                |
   +-----------------------------------------------------------------------------------------------------------+
   1 row in set (0.23 sec)
   
   mysql> select CONVERT_TZ('9999-12-31 23:59:59.999999', 'Pacific/Galapagos', 'Pacific/GalapaGoS');
   +------------------------------+
   | '9999-12-31 23:59:59.999999' |
   +------------------------------+
   | 9999-12-31 23:59:59.999999   |
   +------------------------------+
   1 row in set (0.11 sec) --- finished in FE
   ```
   


-- 
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: commits-unsubscribe@doris.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [branch-2.1](function) fix FE impl of some time functions (#37746) [doris]

Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei merged PR #38316:
URL: https://github.com/apache/doris/pull/38316


-- 
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: commits-unsubscribe@doris.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [branch-2.1](function) fix FE impl of some time functions (#37746) [doris]

Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb commented on PR #38316:
URL: https://github.com/apache/doris/pull/38316#issuecomment-2247587452

   run buildall


-- 
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: commits-unsubscribe@doris.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [branch-2.1](function) fix FE impl of some time functions (#37746) [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38316:
URL: https://github.com/apache/doris/pull/38316#issuecomment-2247587205

   Thank you for your contribution to Apache Doris.
   Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR)
   
   Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
   See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).


-- 
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: commits-unsubscribe@doris.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [branch-2.1](function) fix FE impl of some time functions (#37746) [doris]

Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb commented on PR #38316:
URL: https://github.com/apache/doris/pull/38316#issuecomment-2248327866

   run buildall


-- 
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: commits-unsubscribe@doris.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org