How to Convert a Gregorian Date into Hijri Date using SQL Server 2005?

Question

iam having a date like '1428/01/17'(date is in Hijri Calendar)(format is "yyyy/mm/dd")
I Have to convert it into Gregorian date which is '2007/02/04(format is yyyy/mm/dd).
any body know how to do this,
please help me

Answer 1

I used this to convert from Gregorian to Hijri (must output as a string to preserve Hijri formatting):

CONVERT(varchar(30), GETDATE(), 131)

Obviously you can substitute GETDATE() for any native datetime or smalldatetime value.

To convert from a Hijri-formatted datetime string into a native datetime value:

CONVERT(datetime, '17/01/1428 4:22:24:073AM', 131)

Just insert the Hijri data into the second parameter as a string.

Answer 2

14/04/1445