Click here to Skip to main content
14,207,429 members
Rate this:
 
Please Sign up or sign in to vote.
See more:
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)
Posted
Updated 19-Apr-17 20:26pm

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Searched this site and found; Convert date to hijri format.[^]
   
Comments
Learn.net37 20-Apr-17 3:13am
   
it's not the same question i post , similar but not same
Michael_Davies 20-Apr-17 6:07am
   
The title of your post is "Convert from gregorian to hijri date" and the nut of your question is "i know that i need some kind of convert so please some help me"

If this is not the question then please click Improve Question and refine the problem so people can help you.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Cookies | Terms of Service
Web03 | 2.8.190612.1 | Last Updated 20 Apr 2017
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100