MSSQL Query

MSSQL and TSQL Programming and TSQL Examples

Islamic Calendar Dates in SQL Server

by · Published · Updated

Hello to everyone,

In this article, I will talk about changing the date format to Islamic calendar date format in SQL Server.

You may need Islamic calendar date in SQL Server.

You can use the codes below to change your date in Islamic calendar date format.

130 
SELECT CONVERT(NVARCHAR, GETDATE(), 130);
 dd mmm yyyy hh:mi:ss:nnn AM/PM date output
131 
SELECT CONVERT(NVARCHAR, GETDATE(), 131);
 dd mmm yyyy hh:mi:ss:nnn AM/PM 10/12/1427 12:38:54:840AM

When you run the code, you will get a result like the one below.

Islamic Calendar Dates in SQL Server

As you can see, the date format has been converted to the Islamic date format.

Good luck to everyone in business and life

206 Views

Tags:

Yavuz Selim Kart

I try to explain what I know in software and database. I am still improving myself by doing research on many programming languages. Apart from these, I am also interested in Graphic Design and Wordpress. I also have knowledge about SEO and Social media management. In short, I am a determined person who likes to work hard.

You may also like...

Don`t copy text!