SDU Tools: Nepali Date Processing in SQL Server T-SQL

Our free SDU Tools for developers and DBAs, now includes a very large number of tools, with procedures, functions, and views. Version 27 adds the first set of views and functions for working with Nepali dates. These are useful in Nepal and in a number of Buddhist-related areas.

The first tool added is a view called NepaliMonths. It returns the Nepali names for months. You can see it in the main image above.

The next tool added is a view called NepaliMonthDays. It maps year numbers and month numbers to the length of each month. It is a complex pattern in Nepali date processing, so a limited range of dates is supported.

They also provide options to convert between English dates and Nepali dates (EnglishDateToNepaliDate) and vice-versa (NepaliDateToEnglishDate).

This function is computationally intensive. If you have large volumes of data to compare, consider modifying it to a table-valued function.

Find out more

You can see it in action in the main image above, and in the video here:

You can use our tools as a set or as a great example of how to write functions like these.

Access to SDU Tools is one of the benefits of being an SDU Insider, along with access to our other free tools and eBooks. Please just visit here for more info:

http://sdutools.sqldownunder.com

2026-04-06