79435997

Date: 2025-02-13 11:35:56
Score: 0.5
Natty:
Report link

The simplest function that matches the examples that you provided is FLOOR(value) + 0.5.

Here's an example:

SELECT 
  value, FLOOR(value) + 0.5
FROM UNNEST([0.01, 2.3913, 4.6667, 2.11]) AS value
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Malaman