TiDB Cloud
TiDB Self-Managed
Learning Center
Contact Us
​
​
Sign InStart for Free
🚀

Explore the new TiDB Labs, learn distributed SQL database and build RAG apps directly from your browser.
  • Docs Home
  • About TiDB
  • Quick Start
  • Develop
  • Deploy
  • Migrate
  • Integrate
  • Maintain
  • Monitor and Alert
  • Troubleshoot
  • Performance Tuning
  • Tutorials
  • TiDB Tools
  • Reference
    • Cluster Architecture
    • Storage Engine - TiKV
    • Storage Engine - TiFlash
    • System Variables
    • Configuration File Parameters
    • CLI
    • Command Line Flags
    • Key Monitoring Metrics
    • Privileges
    • SQL
      • SQL Language Structure and Syntax
      • SQL Statements
      • Data Types
      • Functions and Operators
        • Overview
        • Type Conversion in Expression Evaluation
        • Operators
        • Control Flow Functions
        • String Functions
        • Numeric Functions and Operators
        • Date and Time Functions
        • Bit Functions and Operators
        • Cast Functions and Operators
        • Encryption and Compression Functions
        • Locking Functions
        • Information Functions
        • JSON Functions
        • Aggregate (GROUP BY) Functions
        • Window Functions
        • Miscellaneous Functions
        • Precision Math
        • Set Operations
        • List of Expressions for Pushdown
        • TiDB Specific Functions
        • Comparisons between Functions and Syntax of Oracle and TiDB
      • Clustered Indexes
      • Constraints
      • Generated Columns
      • SQL Mode
      • Table Attributes
      • Transactions
      • Views
      • Partitioning
      • Temporary Tables
      • Cached Tables
      • Character Set and Collation
      • Placement Rules in SQL
      • System Tables
      • Metadata Lock
    • UI
    • Telemetry
    • Error Codes
    • Table Filter
    • Schedule Replicas by Topology Labels
  • FAQs
  • Release Notes
  • Glossary

Type Conversion in Expression Evaluation

TiDB behaves the same as MySQL: https://dev.mysql.com/doc/refman/5.7/en/type-conversion.html

Was this page helpful?

Download PDFRequest docs changesAsk the community
What's on this page
    Products
    TiDB Cloud Serverless
    TiDB Cloud Dedicated
    TiDB Self-Managed
    Pricing
    Ecosystem
    Integrations
    TiKV
    TiFlash
    OSS Insight
    Resources
    Blog
    Forum
    Events & Webinars
    HTAP Summit
    Docs
    Developer Guide
    FAQs
    Support
    Company
    About Us
    News
    Careers
    Contact Us
    Partners
    Trust Center
    Security
    Release Support
    Stay Connected
    © 2025 PingCAP. All Rights Reserved.
    /
    Privacy Policy
    /
    Legal