📣New in Public Preview: TiDB Cloud BYOC, TiDB Cloud Filesystem, PostgreSQL-compatible TiDB Cloud Starter
​
​
Sign InStart for Free
Product
AI
Developer
Best Practices
API
Releases
​
​
Sign InStart for Free
TiDB Cloud Dedicated

    GET STARTED


  • Why TiDB Cloud
  • Get Started
  • Key Concepts
  • GUIDES


  • Plan Your Cluster
  • Manage TiDB Cloud Resources and Projects
  • Manage TiDB Cloud Dedicated Clusters
  • Migrate or Import Data
  • Explore Data
  • Data Service
    Preview
  • Stream Data
  • Security
  • Billing
  • Integrations
  • REFERENCE


  • SQL Reference
    • Explore SQL with TiDB
    • 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
      • GROUP BY Modifiers
      • Window Functions
      • Sequence Functions
      • Utility Functions
      • Miscellaneous Functions
      • TiDB Specific Functions
      • Utility Functions
      • Precision Math
      • Set Operations
      • List of Expressions for Pushdown
    • Clustered Indexes
    • Global Indexes
    • Constraints
    • Generated Columns
    • SQL Mode
    • Table Attributes
    • Transactions
    • Views
    • Partitioning
    • Temporary Tables
    • Cached Tables
    • FOREIGN KEY Constraints
    • Character Set and Collation
    • Read Historical Data
    • Placement Rules in SQL
    • System Tables
    • Metadata Lock
    • TiDB Accelerated Table Creation
    • Schema Cache
  • General Reference
  • Support Plan
  • FAQs
  • Glossary

Type Conversion in Expression Evaluation



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

Was this page helpful?

Product
Product Overview
TiDB Cloud
TiDB Self-Managed
Pricing
Ecosystem
Integrations
TiKV
TiFlash
OSS Insight
Resources
Blog
Articles
Events & Webinars
Docs
Developer Guide
FAQs
Support
llms.txt
Company
About Us
News
Careers
Contact Us
Partners
Trust Hub
Security
Release Support
Brand Guidelines
Stay Connected
© 2026 PingCAP. All Rights Reserved.
/
Privacy Policy
/
Legal