Monday, 21 February 2011

Round the number and always show decimal places...

The following is the way to round the number and always show two decimal places:

SELECT to_char(round(678,2), '9999999.99') FROM dual;

No comments:

Post a Comment

Using Handlebar Prompt in Semantic Kernal

> dotnet add package Microsoft.SemanticKernel.PromptTemplates.Handlebars --version 1.30.0 using Microsoft . SemanticKernel ; using Micr...