After installing and getting started with Python, the very first exercise I did was to print the current date time in Python. Let us learn about it today.
SQL SERVER – Find Business Days Between Dates
I often receive a very common question during my Comprehensive Database Performance Health Check about how to find Find Business Days Between Dates.
SQL SERVER – Display Dates in Different cultures FORMAT
Today we are going to learn a very simple and interesting concept used very little. It is about how to Display Dates in Different cultures FORMAT.
SQL SERVER – CONVERT Empty String To Null DateTime
Let us learn today how to CONVERT Empty String To Null DateTime. While I focus on SQL Server Performance Health Check, let us learn about it today.
SQL SERVER – Convert Date Time AT TIME ZONE
My client last week about Comprehensive Database Performance Health Check. The question was how to Convert Date Time AT TIME ZONE.
SQL SERVER – List All Dates Between Start and End Date
We will see a very simple script where we will take advantage of the Common Table Expression and list all dates between two dates (Start and End Date).
SQL SERVER – Convert Formatted Integer Values into Date
One of my clients of Comprehensive Database Performance Health Check asked me a question about how to Convert Formatted Integer Values into Date.