Skip to content

Add CEILING function#746

Merged
MarkMpn merged 3 commits into
MarkMpn:masterfrom
sulimanbenhalim:add-ceiling-function
Mar 16, 2026
Merged

Add CEILING function#746
MarkMpn merged 3 commits into
MarkMpn:masterfrom
sulimanbenhalim:add-ceiling-function

Conversation

@sulimanbenhalim

Copy link
Copy Markdown
Contributor

Adds the CEILING function which returns the smallest integer greater than, or equal to, the specified numeric expression.

Changes

  • ExpressionFunctions.cs — six overloads covering all supported numeric types: int, bigint, decimal, float, money, real
  • FunctionMetadata.cs — autocomplete/IntelliSense entry
  • ExpressionFunctionTests.cs — unit tests covering positive, negative, fractional, whole, and null inputs

Usage

SELECT CEILING(4.1)   -- 5
SELECT CEILING(-4.9)  -- -4
SELECT CEILING(5.0)   -- 5

@sonarqubecloud

Copy link
Copy Markdown

@MarkMpn MarkMpn merged commit 16c54f8 into MarkMpn:master Mar 16, 2026
2 checks passed
@sulimanbenhalim sulimanbenhalim deleted the add-ceiling-function branch March 16, 2026 12:36
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants