How to display SQL server money format correctly in Editor

How to display SQL server money format correctly in Editor

martinconnollybartmartinconnollybart Posts: 6Questions: 3Answers: 0

Hi, I have a column stored in the 'Money' format in SQL server. The data returned from PHP shows four decimal places, (so 100.00 is shown as 100.0000. I can format this to 2 decimal places in the datatable column using this snippet:
render: DataTable.render.number(null, null, 2)

I can see that the getFormatter() and setFormatter() methods should be used in my PHP, but how? The inbuilt formats don't seem to fit the bill.
Thanks

This question has an accepted answers - jump to answer

Answers

Sign In or Register to comment.