Numeric and Date-time data types in SQL Server Last Updated : 15 Sep, 2020 Comments Improve Suggest changes Like Article Like Report MS SQL Server supports a wide range of data types. There are a few more important data types that are included in the article. In this article, we will cover numeric SQL server data types and different date-time data types. Let’s discuss one by one. bit : A bit is the smallest unit of a computer system. A bit can be either 0 or 1. The bit datatype can take NULL values as well. Syntax – column_name bit; A bit can take up to 8 bytes of storage while 2 bits can take up to 16 bits and the cycle continues. int : A data type that can store integer values(positive and negative). The storage size is up to 8 bytes(-2⁶³ to 2⁶³-1). It is sub-categorized into tinyint, int, smallint, bigint. They can be used according to the number of bytes that can be stored. (i). bigint - A numeric integer datatype that has the maximum storage of 8 bytes.(-2⁶³ to 2⁶³-1). It can store positive and negative values as well. It can be used for storing huge numbers. Syntax – column_name bigint; (ii). int - A numeric integer datatype having a storage size of 4 bytes. Syntax – column_name int; (iii). smallint - A numeric integer type that stores 2 bytes of data. Syntax – column_name smallint; (iv). tinyint - A numeric datatype that stores 1 byte. Syntax – column_name tinyint; For example, a student roll number in a class table can be assigned as follows. rollnumber int; SQL server Numeric Data Types Table : Numeric Data TypeInteger size (In Bytes)bit Value(0, 1 or NULL)tinyint1 smallint2 int4 bigint8 decimal(p,s)5 to 17 numeric(p,s)5 to 17 smallmoney4 money8 float(n)4 or 8 real4 decimal : A data type that can store decimal values. This datatype can be used for storing percentage values. Syntax – column_name decimal(precision, scale) For example, percentage(4,3) Precision is a term used for describing the number of digits to be stored from left to right while the scale is a term used for storing the number of digits after the decimal point. Take the instance of e-commerce where the product delivery date and time are to be stored in the database. For such cases, there are few data types supported by MS SQL SERVER: date : It stores the date in the format of yyyy-mm-dd. Syntax – date time : It stores the time based on 24 hours clock. Syntax – time datetime2 : It stores the date and time as well in the format of yyyy-mm-dd hh:mm: ss. Syntax – datetime2 There are data types that can store money, unique identifiers, XML data, and much more. However, in the future versions of SQL Server, some data types will be removed for some reason. Make sure to use the data types that are available in the SQL Server. Different types of date-time data types table in the SQL server as follows: Data typeSize (In Bytes)datetime8 datetime26 to 8 smalldatetime4 date3 time3 to 5datetimeoffset8 to 10 timestampUnique no. Comment More infoAdvertise with us Next Article Numeric and Date-time data types in SQL Server M mangalgiaishwarya2 Follow Improve Article Tags : SQL Data Types SQL-Server Similar Reads SQL Interview Questions Are you preparing for a SQL interview? SQL is a standard database language used for accessing and manipulating data in databases. It stands for Structured Query Language and was developed by IBM in the 1970's, SQL allows us to create, read, update, and delete data with simple yet effective commands. 15+ min read SQL Tutorial SQL is a Structured query language used to access and manipulate data in databases. SQL stands for Structured Query Language. We can create, update, delete, and retrieve data in databases like MySQL, Oracle, PostgreSQL, etc. Overall, SQL is a query language that communicates with databases.In this S 11 min read SQL Commands | DDL, DQL, DML, DCL and TCL Commands SQL commands are crucial for managing databases effectively. These commands are divided into categories such as Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL), Data Query Language (DQL), and Transaction Control Language (TCL). In this article, we will e 7 min read SQL Joins (Inner, Left, Right and Full Join) SQL joins are fundamental tools for combining data from multiple tables in relational databases. Joins allow efficient data retrieval, which is essential for generating meaningful observations and solving complex business queries. Understanding SQL join types, such as INNER JOIN, LEFT JOIN, RIGHT JO 6 min read Introduction of DBMS (Database Management System) A Database Management System (DBMS) is a software solution designed to efficiently manage, organize, and retrieve data in a structured manner. It serves as a critical component in modern computing, enabling organizations to store, manipulate, and secure their data effectively. From small application 8 min read SQL Query Interview Questions SQL or Structured Query Language, is the standard language for managing and manipulating relational databases such as MySQL, Oracle, and PostgreSQL. It serves as a powerful tool for efficiently handling data whether retrieving specific data points, performing complex analysis, or modifying database 15 min read CTE in SQL In SQL, a Common Table Expression (CTE) is an essential tool for simplifying complex queries and making them more readable. By defining temporary result sets that can be referenced multiple times, a CTE in SQL allows developers to break down complicated logic into manageable parts. CTEs help with hi 6 min read Window Functions in SQL SQL window functions are essential for advanced data analysis and database management. They enable calculations across a specific set of rows, known as a "window," while retaining the individual rows in the dataset. Unlike traditional aggregate functions that summarize data for the entire group, win 7 min read SQL | WITH Clause SQL queries can sometimes be complex, especially when you need to deal with multiple nested subqueries, aggregations, and joins. This is where the SQL WITH clause also known as Common Table Expressions (CTEs) comes in to make life easier. The WITH Clause is a powerful tool that simplifies complex SQ 6 min read SQL Exercises : SQL Practice with Solution for Beginners and Experienced SQL (Structured Query Language) is a powerful and flexible tool for managing and manipulating relational databases. Regardless of our experience level, practising SQL exercises is essential for improving our skills. Regular practice not only enhances our understanding of SQL concepts but also builds 15+ min read Like