Troubleshooting Issues when Working with Date and Time in SQL Server

Total: 1 Average: 5

The Microsoft SQL Server database stores the date and time information in a variety of formats. The most common of them are DateTime, DateTime2, and Date. As it happens with all types of data, issues can take place time after time. In this article, we’ll focus on troubleshooting some of the most common issues that you might face while working with the SQL time and date data types.

CodingSight - Troubleshooting Issues when Working with Date and Time in SQL Server
Read More

Converting DateTime to YYYY-MM-DD Format in SQL Server

Total: 1 Average: 5

An SQL Server database can store a variety of data types, such as numbers, text strings, Boolean values, dates, etc. However, storing and handling such data have their specificities. The current article will focus on storing dates in an SQL Server database table and converting different types of dates into the SQL Server format YYYY-MM-DD and vice versa.

Let’s start!

CodingSight - Converting DateTime to YYYY-MM-DD Format in SQL Server
Read More