In this article, you will learn how to get the current timezone of the server in SQL Server. A very common question we developers often encounter is what is the current Timezone of the server where the SQL Server is installed. Here are the two examples to get the current timezone of the server in SQL Server.
Read More..In this article, you’ll learn how to get the list of supported timezones in SQL Server. Microsoft SQL Server provides the sys.time_zone_info server-wide configuration view which returns a list of supported time zones.
Read More..In this article, you’ll learn how to convert a month name to the month number in SQL Server. In SQL Server, there are no built-in functions to get a month number from a month name. So, here, you can use the MONTH()andDATEPART() functions to convert a month name to its corresponding month number.
Read More..In this article, you’ll learn how to get or return the ISO week number from a date in SQL Server. In this article, we use the two ways to get the ISO week number from a date. One is the DATEPART() function and the second one is a user-defined function.
Read More..In this article, you will learn how to get or extract the week number of a year from a date in SQL Server. You can use the DATEPART() function to get the week number of a year from a date.
Read More..In this article, you will learn how to get or extract the months from a date in SQL Server(T-SQL). Here in this article, we are doing this in 3 ways to extract the month from a date. We are using the MONTH(), DATEPART(), FORMAT() functions to get or extract the month from a date in SQL Server.
Read More..In this article, you will learn how to check or find the column name which is the primary key column of a specific table in SQL Server. There are various ways to find the primary key column in SQL server.
Read More..In this article, you will learn how to add and subtract years, months, weeks, days, hours, minutes, seconds, milliseconds, microseconds, nanoseconds from DateTime in the SQL server. DateTime manipulation is the most common scenario is when we fetching data from the database or storing data in a database. Here, in this article, we will use the SQL server built-in DATEADD() function to add or subtract the days from the specific date.
Read More..In this article, you will learn how to calculate the number of months between two specific dates in SQL Server. To get a number of months between two specific dates, we use the DATEDIFF function of SQL Server.
Read More..In this article, you will learn how to calculate total no. of days between two specific dates in SQL Server. To get a total no. of days between two specific dates, we use the DATEDIFF function of SQL Server.
Read More..