思维导图备注

MatrixOne v0.5.1 Documentation
首页 白天 夜间 BookChat 小程序 小程序 阅读
  • 书签 我的书签
  • 添加书签 添加书签 移除书签 移除书签

Cast Functions and Operators Overview

 Github  来源:MatrixOne 浏览 126 扫码 分享 2023-07-17 22:26:10
  • Cast Functions and Operators

    Cast Functions and Operators

    NameDescription
    CAST()Cast a value as a certain type
    CONVERT()Cast a value as a certain type
    当前内容版权归 MatrixOne 或其关联方所有，如需对内容或内容相关联开源项目进行关注与资助，请访问 MatrixOne .
    上一篇:
    下一篇:
    • 书签
    • 添加书签 移除书签
    • MatrixOne v1.1 中文文档
    • MatrixOne v1.1 Documentation
    • MatrixOne v1.0 中文文档
    • MatrixOne v0.8.0 中文文档
    • MatrixOne v0.8.0 Documentation
    • MatrixOne v0.7.0 Documentation
    • MatrixOne v0.7.0 中文文档
    • MatrixOne v0.6.0 Documentation
    • MatrixOne v0.6.0 中文文档
    • MatrixOne v0.5.1 Documentation
    • MatrixOne v0.4 中文文档
    • MatrixOne v0.4 Documentation
    • MatrixOne v0.3 中文文档
    • MatrixOne v0.3 Documentation
    • MatrixOne
    • Home
    • Overview
      • MatrixOne Introduction
      • MatrixOne Architecture
      • What’s New
    • Getting Started
      • Install Standalone MatrixOne
      • Connect to MatrixOne Server
    • Developing Guide
      • Connect to MatrixOne
        • Using client connect to the MatrixOne
        • Using Java connect to the MatrixOne
        • Using Python connect to the MatrixOne
      • Import Data
        • Import Data
      • Export Data
        • Export data
      • Example Application
        • Build a simple Java CRUD demo with MatrixOne
        • Python stock analysis Demo
    • Maintenance
      • Upgrade Standalone MatrixOne
    • Migration
      • Migrate data from MySQL to MatrixOne
    • Testing
      • Performance Testing
        • SSB Test with MatrixOne
        • TPCH Test with MatrixOne
      • Testing Tool
        • MO-Tester
    • Reference
      • SQL Reference
        • DDL
          • CREATE DATABASE
          • CREATE TABLE
          • DROP DATABASE
          • DROP TABLE
          • PRIMARY KEY
        • DML
          • INSERT
          • INSERT INTO SELECT
          • UPDATE
          • DELETE
          • LOAD DATA
          • SELECT
          • SHOW DATABASES
          • SHOW TABLES
          • USE
          • INTERVAL
          • With CTE
          • SUBQUERY
            • SUBQUERY Overview
            • Derived Tables
            • Comparisons Using Subqueries
            • SUBQUERY with ANY or SOME
            • SUBQUERY with ALL
            • SUBQUERY with EXISTS
            • SUBQUERY with IN
          • JOIN
            • JOIN Overview
            • INNER JOIN
            • LEFT JOIN
            • RIGHT JOIN
            • FULL JOIN
            • OUTER JOIN
            • NATURAL JOIN
          • OPERATORS
            • OPERATORS Overview
            • OPERATORS Precedence
            • Arithmetic Operators
              • Arithmetic Operators Overview
              • %,MOD
              • *
              • +
              • -
              • -
              • /
              • DIV
            • Assignment Operators
              • Assignment Operators Overview
              • \=
            • Cast Functions and Operators
              • Cast Functions and Operators Overview
              • CAST
              • CONVERT
            • Comparison Functions and Operators
              • Comparison Functions and Operators Overview
              • >
              • >=
              • <
              • <>,!=
              • <=
              • \=
              • BETWEEN … AND …
              • IN
              • IS
              • IS NOT
              • IS NOT NULL
              • IS NULL
              • LIKE
              • NOT BETWEEN … AND …
              • NOT LIKE
            • Flow Control Functions
              • Flow Control Functions Overview
              • CASE WHEN
              • IF
            • Logical Operators
              • Logical Operators Overview
              • AND,&&
              • NOT,!
              • OR
              • XOR
        • Aggregate Functions
          • AVG
          • COUNT
          • MAX
          • MIN
          • SUM
          • ANY_VALUE
          • BIT_AND
          • BIT_OR
          • BIT_XOR
          • STDDEV_POP
          • VAR
        • Transactions
          • Transaction Overview
        • Explain
          • EXPLAIN
          • EXPLAIN Output Format
      • Data Types
        • Date Types Overview
        • Data Type Conversion
        • Fixed-Point Types (Exact Value) - DECIMAL
      • Builtin Functions
        • Mathematical
          • ABS()
          • SIN()
          • COS()
          • TAN()
          • COT()
          • ACOS()
          • ATAN()
          • SINH()
          • FLOOR()
          • ROUND()
          • CEIL()
          • POWER()
          • PI()
          • LOG()
          • LN()
          • EXP()
        • Datetime
          • YEAR()
          • MONTH()
          • DATE()
          • WEEKDAY()
          • DAYOFYEAR()
          • EXTRACT()
          • DATE_ADD()
          • DATE_SUB()
          • TO_DATE()
          • UNIX_TIMESTAMP
          • FROM_UNIXTIME
          • UTC_TIMESTAMP()
        • String
          • CONCAT_WS()
          • FIND_IN_SET()
          • OCT()
          • EMPTY()
          • LENGTH()
          • CHAR_LENGTH()
          • LTRIM()
          • RTRIM()
          • LPAD()
          • RPAD()
          • STARTSWITH()
          • ENDSWITH()
          • SUBSTRING()
          • SPACE()
          • REVERSE()
      • System Paramaters
        • General Settings
      • MySQL Compatibility
      • MatrixOne Catalog
    • FAQs
      • Product FAQs
      • Deployment FAQs
      • SQL FAQs
    • Release Notes
      • Release Timeline
      • v0.5.1
      • v0.5.0
      • v0.4.0
      • v0.3.0
      • v0.2.0
      • v0.1.0
    • Glossary
    • Contribution Guide
      • Make Your First Contribution
      • How to Contribute
        • Types of Contributions
        • Preparation
        • Report an Issue
        • Contribute Code
        • Review a Pull Request
        • Contribute Documentation
        • Make a Design
      • Code Style
        • Code of Conduct
        • Code Comment Style
        • Commit & Pull Request Style
    暂无相关搜索结果！

      本文档使用 BookStack 构建

      展开/收起文章目录

      分享，让知识传承更久远

      文章二维码

      手机扫一扫，轻松掌上读

      文档下载

      • 普通下载
      • 下载码下载(免登录无限下载)
      你与大神的距离，只差一个APP
      APP下载
      请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
      PDF文档 EPUB文档 MOBI文档
      温馨提示 每天每在网站阅读学习一分钟时长可下载一本电子书，每天连续签到可增加阅读时长
      下载码方式下载：免费、免登录、无限制。 免费获取下载码

      微信小程序阅读

      BookChat 微信小程序阅读
      您与他人的薪资差距，只差一个随时随地学习的小程序

      书签列表

        阅读记录

        阅读进度: 0.00% ( 0/0 ) 重置阅读进度