convert from hijri date to julian date?

• elham_azizi_62

  SSCertifiable

  Points: 5095

  More actions

  October 20, 2010 at 3:47 am

  #241891

  hi all.

  how to convert hijri date to julian date?for example:1389/07/25(hijri date)to (20/10/2010).plz get me procedure or function for this goal.thanks

• winash

  SSChampion

  Points: 11446

  More actions

  October 20, 2010 at 5:47 am

  #1239596

  From http://msdn.microsoft.com/en-us/library/ms187928(v=SQL.100).aspx 130 and 131 are styles to convert Hijri...

  more information here: http://think-sql.blogspot.com/2009/09/working-with-hijri-date-in-sql-server.html