Click here to Skip to main content
14,176,878 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)
Updated 19-Apr-17 20:26pm

1 solution

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

Solution 1

Searched this site and found; Convert date to hijri format.[^]
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)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Cookies | Terms of Service
Web04 | 2.8.190526.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