In this comprehensive article, I’ll walk you through everything you need to know about manipulating dates in SQL Server – from basic operations to advanced techniques. Let’s dive in. SQL Server Date Math Before we explore the specifics, it’s essential to understand why date manipulation is so critical in database applications: Check out SQL Server … 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 comprehensive article, I’ll walk you through everything you need to know about converting dates to strings in SQL Server. How To Convert Date To String In SQL Server Let’s explore all the methods available to convert dates to strings in SQL Server. Approach 1: Using the CONVERT() Function The CONVERT() function is the … 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
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
In this comprehensive article, I’ll walk you through multiple approaches to subtract days from dates in SQL Server, complete with real-time examples and best practices. SQL Server Subtract Days From Date Before diving into the syntax, let’s consider why this is so essential. You may wish to calculate payment due dates, determine shipping deadlines, and … Read more
In this comprehensive guide, I’ll walk you through everything you need to know about working with system dates in SQL Server, from basic date retrieval to complex date manipulations for different business applications. System Date In SQL Server Let’s start with the fundamental functions for retrieving the system date and time in SQL Server. Approach … 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 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
Recently, I was inserting a date in a table in SQL Server, and after executing the insert query, I got this error SQL Server conversion failed when converting date and/or time from character string. SQL Server conversion failed when converting date and/or time from character string. I executed the SQL query below to insert a … Read more