decimal_bytes.sql 614 B

1234567891011121314
  1. select ToBytes(Decimal("14.2",5,1)),
  2. ToBytes(Decimal("inf",5,1)),
  3. ToBytes(Decimal("-inf",5,1)),
  4. ToBytes(Decimal("nan",5,1)),
  5. ToBytes(Nothing(Optional<Decimal(5,1)>));
  6. select FromBytes(ToBytes(Decimal("14.2",5,1)),Decimal(5,1)),
  7. FromBytes(ToBytes(Decimal("10",5,1)),Decimal(2,1)),
  8. FromBytes(ToBytes(Decimal("-10",5,1)),Decimal(2,0)),
  9. FromBytes(ToBytes(Decimal("inf",5,1)),Decimal(5,1)),
  10. FromBytes(ToBytes(Decimal("-inf",5,1)),Decimal(5,1)),
  11. FromBytes(ToBytes(Decimal("nan",5,1)),Decimal(5,1)),
  12. FromBytes(Nothing(String?),Decimal(5,1));