As a senior database developer, I often receive requirements to utilize the date data type in SQL Server. In this comprehensive article, I’ll walk you through everything you need to know about SQL Server date data types. SQL Server Date Data Types Why Date Data Types in SQL Server Before diving into the specifics, let’s … Read more
As a senior developer working with SQL Server, I have frequently used date and datetime data types. In this article, I’ll walk you through everything you need to know about SQL Server’s date and time data types, with a special focus on the differences between the DATE and DATETIME data types. SQL Server Date vs … Read more
In this article, I’ll walk you through everything you need to know about working with date ranges in SQL Server, with a specific focus on the BETWEEN operator. SQL Server Date Between Before diving into specific techniques, it’s essential to understand how SQL Server handles dates. SQL Server stores dates in a standardized internal format, … Read more
In this comprehensive article, I’ll walk you through everything you need to know about SQL Server date formatting—from basic conversions to advanced techniques, followed by the best practices. SQL Server Date Formatting Before diving into the specifics, let’s understand why date formatting is so crucial. The United States follows the MM/DD/YYYY format (06/10/2025), whereas many … Read more
Most of the time, I was required to add the time to the date, being a senior SQL Server resource. In this comprehensive article, I’ll walk you through multiple approaches on how to add time to a date in SQL Server. SQL Server Add Time To Date Before diving into specific approaches, it’s important to … Read more
In this comprehensive article, I’ll cover everything you need to know about using greater than operators with dates in SQL Server, from basic syntax to advanced techniques. SQL Server Greater Than Date Before diving into specific techniques, it’s essential to understand how SQL Server handles date comparisons. Unlike some programming languages, where dates require special … Read more
In this comprehensive article, I’ll cover everything you need to know about using dates in SQL Server WHERE clauses, from basic syntax to advanced techniques. SQL Server Date In Where Clause The first challenge when working with dates in SQL Server is understanding the available data types. Common Date Data Types in SQL Server SQL … Read more
Recently, I was trying to insert some date and time values into one of the SQL server tables named USAOrders, which contains 2 columns of the datetime datatype. After executing the insert query, I got this error. The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. I … Read more
Recently, I was working on a requirement to extract the year from a date in SQL Server. After executing the SQL query, I got this error. ‘EXTRACT’ is not a recognized built-in function name. I was executing the following query. After executing the above query, I got this error as shown in the screenshot below. … Read more
In this comprehensive article, I’ll provide real-time examples of multiple approaches to extracting the month from a date in SQL Server. This is one of the requirements that I recently got for one of my applications. SQL Server Get Month From Date Let us discuss all the possible approaches individually. Approach 1: Using the MONTH() … Read more