FORMAT Built-in Function [CORE3776] #4120
Comments
Modified by: Miguel Suarez (kiux)description: Hi Firebird developers, Are you able to develop the "FORMAT" Built-in Function for Firebird? I think that you can. Sample: SELECT FORMAT(0.125, '0.00%') FROM ... Sample: SELECT FORMAT(CURENT_DATE, 'dddd, MMM d yyyy') FROM ... Sample: SELECT FORMAT(5459.4, 'US$##,##0.00') FROM ... => Hi Firebird developers, Are you able to develop the "FORMAT" Built-in Function for Firebird? I think that you can. Sample: SELECT FORMAT(0.125, '0.00%') FROM ... Sample: SELECT FORMAT(CURRENT_DATE, 'dddd, MMM d yyyy') FROM ... Sample: SELECT FORMAT(5459.4, 'US$##,##0.00') FROM ... |
Modified by: Miguel Suarez (kiux)timeestimate: 1209600 [ 1209600 ] timeoriginalestimate: 1209600 [ 1209600 ] Component: Engine [ 10000 ] Component: UDF [ 10002 ] => |
Modified by: Miguel Suarez (kiux)timeestimate: 1209600 [ 1209600 ] => timeoriginalestimate: 1209600 [ 1209600 ] => |
|
Commented by: @asfernandes Duplicates CORE1314. |
Modified by: @asfernandes |
Modified by: Miguel Suarez (kiux)description: Hi Firebird developers, Are you able to develop the "FORMAT" Built-in Function for Firebird? I think that you can. Sample: SELECT FORMAT(0.125, '0.00%') FROM ... Sample: SELECT FORMAT(CURRENT_DATE, 'dddd, MMM d yyyy') FROM ... Sample: SELECT FORMAT(5459.4, 'US$##,##0.00') FROM ... => THIS ISSUE IS NOT EQUAL TO CORE1314 Hi Firebird developers, Are you able to develop the "FORMAT" Built-in Function for Firebird? I think that you can. Sample: SELECT FORMAT(0.125, '0.00%') FROM ... Sample: SELECT FORMAT(CURRENT_DATE, 'dddd, MMM d yyyy') FROM ... Sample: SELECT FORMAT(5459.4, 'US$##,##0.00') FROM ... THIS ISSUE IS NOT EQUAL TO CORE1314 |
|
Commented by: @asfernandes The tickets talks about the same thing. Both are surely very naively described, BTW, which leaves the complete design to the developer. This is, however, not the reason it was not added yet. The reason is described in CORE1341 comment. |
|
Commented by: Van den Wouwer Danny (dannyvdw) Is this kind of functionality indeed needed in the Firebird engine? My personal opnion says that formatting data should be done on the presentation layer, it is there that you know the culture/environment of the user. One of the examples says: This means, to correct the example above, you should use something like this: And probably it will not stop here, Formatting is much more complex then adding a STRING_FORMAT. |
Submitted by: Miguel Suarez (kiux)
Duplicates CORE1314
THIS ISSUE IS NOT EQUAL TO CORE1314
Hi Firebird developers,
Are you able to develop the "FORMAT" Built-in Function for Firebird? I think that you can.
Sample: SELECT FORMAT(0.125, '0.00%') FROM ...
Returns: '12.50%'
Sample: SELECT FORMAT(CURRENT_DATE, 'dddd, MMM d yyyy') FROM ...
Returns: 'Sunday, Feb 26 2012'
Sample: SELECT FORMAT(5459.4, 'US$##,##0.00') FROM ...
Returns: 'US$5,459.40'
THIS ISSUE IS NOT EQUAL TO CORE1314
The text was updated successfully, but these errors were encountered: