assay
test suite

parser

34 tests · 29 with documented divergences

Test Subject Formula Category DVs
de0865 CONVERT =CONVERT(1, "ft", "in") value 2
a62050 CONVERT =CONVERT(1, "m", "ft") value
28ce45 CONVERT =CONVERT(1, "kg", "lbm") value
70c9f4 CONVERT =CONVERT(100, "C", "F") value 2
dfc8b1 CONVERT =CONVERT(1, "hr", "sec") value 1
f770af CONVERT =CONVERT(1, "km", "mi") value
40b5c9 CONVERT =CONVERT(1, "ft", "kg") value
3a1a27 CONVERT =CONVERT(1, "xyz", "in") value
b6afb1 TO_DATE =TO_DATE(44000) value 2
559669 TO_DATE =TO_DATE(0) value 2
d9785e TO_DATE =TO_DATE("2024-01-15") value 2
75dec7 TO_DATE =TO_DATE(TRUE) value 2
82780c TO_DATE =TO_DATE("not-a-date") value 2
020da0 TO_DOLLARS =TO_DOLLARS(1234) value 2
43c179 TO_DOLLARS =TO_DOLLARS(1234.567) value 2
ad81c7 TO_DOLLARS =TO_DOLLARS(-42.5) value 2
456aa0 TO_DOLLARS =TO_DOLLARS("99.99") value 2
d1d2b2 TO_DOLLARS =TO_DOLLARS(TRUE) value 2
386552 TO_PERCENT =TO_PERCENT(0.25) value 2
8d92d1 TO_PERCENT =TO_PERCENT(1) value 2
a687b5 TO_PERCENT =TO_PERCENT(0) value 2
1ee896 TO_PERCENT =TO_PERCENT("0.5") value 2
e3efd5 TO_PERCENT =TO_PERCENT(-0.1) value 2
cf307f TO_PURE_NUMBER =TO_PURE_NUMBER(0.25) value 2
3a7578 TO_PURE_NUMBER =TO_PURE_NUMBER(42) value 2
377e5a TO_PURE_NUMBER =TO_PURE_NUMBER("123.45") value 2
36eab0 TO_PURE_NUMBER =TO_PURE_NUMBER(TRUE) value 2
d2159b TO_PURE_NUMBER =TO_PURE_NUMBER("hello") value 2
175a5b TO_TEXT =TO_TEXT(42) value 2
6d5ac5 TO_TEXT =TO_TEXT(3.14159) value 2
b5c613 TO_TEXT =TO_TEXT(TRUE) value 2
609e8b TO_TEXT =TO_TEXT("hello") value 2
78d5d6 TO_TEXT =TO_TEXT(A1) value 2
5ae574 TO_TEXT =TO_TEXT(-1234.5) value 2