hello, i have in sql the down below story producer to find the expire date before 45 days
in Gregorian dates, now how can i find the expire date using hijri date , i know that i need some kind of convert so please some help me,
* column name as u saw down is LicenseExpiryen
What I have tried:
<pre>SELECT [Purchesdateen], [Purchesdate], [Selleren], [Seller], [Notes], [MoreInformation], [Total],
[Inurancevalue], [OtherCharge], [ShippingCharge], [PurchesValue], [SpareKeys], [InsuranceExpiryen], [InsuranceExpiry], [InsuranceCompany],
convert(varchar, LicenseExpiryen, 111) as LicenseExpiryen ,
[LicenseExpiry], [Orignalen], [Orignal], [Statusen], [Status], [Locationen], [Location], [Userren], [Userr], [Owneren],
[Owner], [Colouren], [CustomerDuties], [Contractno],[Startcontract], [Startcontracten] , [Image]
, [Colour], [Yearen], [Year], [Typeen], [Type], [Platenoen], [Plateno], [No] FROM [ALL_VECH]
where CONVERT(date,LicenseExpiryen,103) <= CONVERT(date,GETDATE()+45,103)