What are common SQL data types?

SQL and database basics · Freshers

Model answer

Numbers (INTEGER, DECIMAL/NUMERIC, FLOAT), text (VARCHAR, TEXT, CHAR), dates and times (DATE, TIME, TIMESTAMP), boolean, and sometimes JSON. Use DECIMAL for money, not FLOAT, to avoid rounding errors. Exact names differ between databases.

Learn this topic

What Is SQL and What Is a Database? in the course SQL for Beginners: Learn Databases Step by Step.

Sign in to add your own answer.

More questions

• What is SQL?
• What is a relational database?
• What is the difference between DDL, DML, DCL and TCL?
• What is the difference between DELETE, TRUNCATE and DROP?
• What is NULL and how do you test for it?
• What is the difference between SQL and MySQL?