从格里高利转换为日期 [英] Convert from gregorian to hijri date

问题描述

你好，我在sql下面的故事制作人找到了45天之前的过期日期

在格里高利日期，现在怎样才能找到使用日期的过期日期，我知道我需要某种转换，所以请一些帮助我，



*你看到的列名是LicenseExpiryen



我尝试了什么：

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)

推荐答案

搜索到这个网站，找到了; 将日期转换为hijri格式。 [ ^ ]

Searched this site and found; Convert date to hijri format.[^]

这篇关于从格里高利转换为日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！