[function] need format to compare two strings

[wangsimo0]

Formats the number X to a format like '#,###,###.##', rounded to D decimal places, and returns the result as a string. If D is 0, the result has no decimal point or fractional part.

please refer to https://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_format

mysql> SELECT FORMAT(12332.123456, 4);
-> '12,332.1235'
mysql> SELECT FORMAT(12332.1,4);
-> '12,332.1000'
mysql> SELECT FORMAT(12332.2,0);
-> '12,332'

[wangsimo0]

@mchades hi could you please reply to this issue so I can assign it to you?

[mchades]

@mchades hi could you please reply to this issue so I can assign it to you?

OK, I will do this

[iiiuwioajdks]

I see the assign of this issue has been a while, can I also try to complete this, I want some simple issue to cut into starrocks to learn better @wangsimo0

[kateshaowanjou]

@iiiuwioajdks Hi buddy, are you still working on this issue？ If you have any questions, feel free to join WeChat for discussion: https://ma3you.com/articles_qrcode_show/b12e90J.png?le_time=220907203008013206

[Jin-H]

@kateshaowanjou @wangsimo0 I want to try this task, can you assign it to me?

[LakshmiGayathri19]

@wangsimo0 Could you please assign this to me, I would like to contribute to this project.
Thanks in advance

[wangsimo0]

sorry for the delay. @Jin-H @LakshmiGayathri19 hi are you still have interest to try this task? sorry again for the delay

[Jin-H]

I want to try it, but it might take some time

[LakshmiGayathri19]

Yea, Even I want to give it a short, but little busy with the end semester projects and exams. I might be free in three weeks, maybe then I will take a look. :")

[wangsimo0]

Thanks both of you for your interest in StarRocks :)! In this case base on your situation, @Jin-H will you take this issue? Take your time and let's keep in touch! And sorry for
@LakshmiGayathri19 , Lakshmi you are always welcomed here and we have plenty of other functions on the list like this one #19616 if you still interested. Best wishes for your projects and exams! Hope to see you in three weeks :) Lets keep in touch!

[Jin-H]

Thanks both of you for your interest in StarRocks :)! In this case base on your situation, @Jin-H will you take this issue? Take your time and let's keep in touch! And sorry for @LakshmiGayathri19 , Lakshmi you are always welcomed here and we have plenty of other functions on the list like this one #19616 if you still interested. Best wishes for your projects and exams! Hope to see you in three weeks :) Lets keep in touch!

ok

[Jin-H]

@wangsimo0 Plz assign it to me, thanks.

[silly-carbon]

hi @wangsimo0
Is anyone still working on this? If no, please re-assign it to me and I will start implementing it now

[Jin-H]

Sorry, I originally planned to deal with it in these two weeks, but I have been busy with work recently and have not had time to do this task. At present, I don’t expect to start doing it until after New Year’s Day in 2024. If you particularly want to try this task, Then do it. @silly-carbon

[silly-carbon]

Sorry, I originally planned to deal with it in these two weeks, but I have been busy with work recently and have not had time to do this task. At present, I don’t expect to start doing it until after New Year’s Day in 2024. If you particularly want to try this task, Then do it. @silly-carbon

@Jin-H thanks mate, OK I'll implement this