How To Convert Gregorian Date to Hijri Date or Hijri Date to Gregorian Date

dbtut February 21, 2019 MSSQL, TSQL

A friend ask to me to conversion about gregorian date to hijri date or hijri date to gregorian date. I will explan this conversions in this article.

First create a table with datetime datatype and insert a record on it.

USER [TESTDB]
GO
CREATE TABLE [dbo].[convert_gregorion_to_hijri_or_hijri_to_gregorian](
[created_date] [datetime] NULL
) ON [PRIMARY]
GO
INSERT INTO [dbo].[convert_gregorion_to_hijri_or_hijri_to_gregorian]
VALUES('2019-01-22 00:00:00.000')

USER [TESTDB]

CREATE TABLE [dbo].[convert_gregorion_to_hijri_or_hijri_to_gregorian](

[created_date] [datetime] NULL

) ON [PRIMARY]

INSERT INTO [dbo].[convert_gregorion_to_hijri_or_hijri_to_gregorian]

VALUES('2019-01-22 00:00:00.000')

Convert Gregorian Date to Hijri Date:

SELECT created_date
      ,CONVERT(varchar(50), created_date,131) AS [Hijri_Created_Date]
FROM [TestDB].[dbo].[convert_gregorion_to_hijri_or_hijri_to_gregorian]

SELECT created_date

,CONVERT(varchar(50), created_date,131) AS [Hijri_Created_Date]

FROM [TestDB].[dbo].[convert_gregorion_to_hijri_or_hijri_to_gregorian]

Convert Hijri Date to Gregorian Date:

SELECT CONVERT(datetime, value, 131)
FROM(
    values ('16/05/1440 12:00:00:000AM')
    ) samples(value)

SELECT CONVERT(datetime, value, 131)

FROM(

values ('16/05/1440 12:00:00:000AM')

) samples(value)

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

How To Convert Gregorian Date to Hijri Date or Hijri Date to Gregorian Date

Convert Gregorian Date to Hijri Date:

Convert Hijri Date to Gregorian Date:

About dbtut

2 comments

Leave a Reply Cancel reply