ToUint64.sql 583 B

1234567891011121314151617181920212223242526272829
  1. /* syntax version 1 */
  2. SELECT
  3. value AS value,
  4. key AS key,
  5. Unicode::ToUint64(value)
  6. FROM Input
  7. WHERE key = "with_format_1"
  8. OR key = "with_format_2"
  9. OR key = "with_format_3"
  10. OR key = "binary_1"
  11. OR key = "binary_2";
  12. SELECT
  13. value AS value,
  14. key AS key,
  15. Unicode::ToUint64(value, 2),
  16. Unicode::ToUint64(value, 16)
  17. FROM Input
  18. WHERE key = "binary_1"
  19. OR key = "binary_2";
  20. SELECT
  21. value AS value,
  22. key AS key,
  23. Unicode::ToUint64(value, 8),
  24. Unicode::ToUint64(value, 10),
  25. Unicode::ToUint64(value, 16)
  26. FROM Input
  27. WHERE key = "zero";