You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2020/01/08 07:32:37 UTC

[GitHub] [incubator-doris] chorylee001 opened a new issue #2703: The date function cannot calculate the month in which the two dates differ

chorylee001 opened a new issue #2703: The date function cannot calculate the month in which the two dates differ
URL: https://github.com/apache/incubator-doris/issues/2703
 
 
   The date function cannot calculate the MONTH in which there is a difference between two dates, such as in mysql  TIMESTAMPDIFF(MONTH,'2018-10-01','2019-10-01 '),the result is 12.
   What should I do?

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

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


[GitHub] [incubator-doris] chorylee001 commented on issue #2703: The date function cannot calculate the month in which the two dates differ

Posted by GitBox <gi...@apache.org>.
chorylee001 commented on issue #2703: The date function cannot calculate the month in which the two dates differ
URL: https://github.com/apache/incubator-doris/issues/2703#issuecomment-577455374
 
 
   Thank you very much,we will use it.
   
   
   在 2020年1月21日,下午12:00,HangyuanLiu <no...@github.com> 写道:
   
   
   
   Hi, we have add timestampdiff function in master branch
   
   —
   You are receiving this because you authored the thread.
   Reply to this email directly, view it on GitHub<https://github.com/apache/incubator-doris/issues/2703?email_source=notifications&email_token=ABVEDOXIF2TAML6CMPRCNLLQ6ZXNHA5CNFSM4KEEBOQ2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEJONDDI#issuecomment-576508301>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ABVEDOTLGQUS3LW7ZBM7PG3Q6ZXNHANCNFSM4KEEBOQQ>.
   

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

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


[GitHub] [incubator-doris] HangyuanLiu commented on issue #2703: The date function cannot calculate the month in which the two dates differ

Posted by GitBox <gi...@apache.org>.
HangyuanLiu commented on issue #2703: The date function cannot calculate the month in which the two dates differ
URL: https://github.com/apache/incubator-doris/issues/2703#issuecomment-576508301
 
 
   Hi, we have add timestampdiff function in master branch

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

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


[GitHub] [incubator-doris] HangyuanLiu commented on issue #2703: The date function cannot calculate the month in which the two dates differ

Posted by GitBox <gi...@apache.org>.
HangyuanLiu commented on issue #2703: The date function cannot calculate the month in which the two dates differ
URL: https://github.com/apache/incubator-doris/issues/2703#issuecomment-571969326
 
 
   There is no function that directly supports calculating the monthly difference. Wd need support TIMESTAMPDIFF  function for Doris.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

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


[GitHub] [incubator-doris] imay closed issue #2703: The date function cannot calculate the month in which the two dates differ

Posted by GitBox <gi...@apache.org>.
imay closed issue #2703: The date function cannot calculate the month in which the two dates differ
URL: https://github.com/apache/incubator-doris/issues/2703
 
 
   

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

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


[GitHub] [incubator-doris] chorylee001 commented on issue #2703: The date function cannot calculate the month in which the two dates differ

Posted by GitBox <gi...@apache.org>.
chorylee001 commented on issue #2703: The date function cannot calculate the month in which the two dates differ
URL: https://github.com/apache/incubator-doris/issues/2703#issuecomment-571970779
 
 
   > There is no function that directly supports calculating the monthly difference. Wd need support TIMESTAMPDIFF function for Doris.
   
   ok,thanks.
   we neet it.I don't think it's just me.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

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