;

Tags: Data Conversion Articles


How to Convert a Month Name to the Month Number in SQL Server

Tutorialsrack 06/06/2021 SQL SQL Server

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..

How to Get or Return the ISO Week Number from a Date in SQL Server

Tutorialsrack 25/02/2021 SQL SQL Server

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..

3 Ways to Get or Extract the Month From a Date in SQL Server

Tutorialsrack 22/02/2021 SQL SQL Server

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..
Recent Posts
Tags