在sqlite中转换查询 [英] convert query in sqlite

问题描述

我需要在android sqlite中使用这个查询，我会通过CustomerNumber任何一个帮助吗？

选择PromotionInfo.promotionnumber为NO，PromotionDesc为DESCRIPTION，CASE PromotionType当'1''那么''AMOUNT''WHEN'' 2''然后''百分比''当''3''那么'买X获得Y''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''作为FREEQTY来自PromotionInfo，CustomerInfo，CustomerPromotionCalender其中（CustomerPromotionCalender.EffectiveStartDate与CustomerPromotionCalender.EffectiveEndDate之间的getdate（））和（PromotionInfo.Promo_Eff_StartDate与PromotionInfo.Promo_Eff_EndDate之间的getdate（））和PromotionInfo.PromotionNumber = CustomerPromotionCalender.PromotionNumber和CustomerInfo.CustomerNumber = CustomerPromotionCalender .CustomerNumber和CustomerInfo.CustomerNumber =''+ CustomerNumber +''

解决方案

而不是getTime（）使用



其

 strft IME（％s’的，现在）

I need to use this query in android sqlite , I''ll pass CustomerNumber can any one help??

SELECT PromotionInfo.promotionnumber as NO,PromotionDesc as DESCRIPTION,CASE PromotionType WHEN ''1'' THEN ''AMOUNT'' WHEN ''2'' THEN ''PERCENTAGE'' WHEN ''3'' THEN ''Buy X Get Y free'' WHEN ''4'' THEN ''Buy X Pay for Y'' END as TYPE,PromotionValue as VALUE,FreeOrPayQuantity as FREEQTY FROM PromotionInfo, CustomerInfo, CustomerPromotionCalender where (getdate() between CustomerPromotionCalender.EffectiveStartDate and CustomerPromotionCalender.EffectiveEndDate) and (getdate() between PromotionInfo.Promo_Eff_StartDate and PromotionInfo.Promo_Eff_EndDate) and PromotionInfo.PromotionNumber = CustomerPromotionCalender.PromotionNumber and CustomerInfo.CustomerNumber = CustomerPromotionCalender.CustomerNumber and CustomerInfo.CustomerNumber =''" + CustomerNumber + "''"

解决方案

its instead of getTime() use

its

strftime(''%s'',''now'')

这篇关于在sqlite中转换查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！