Click here to Skip to main content
12,954,280 members (90,832 online)
Rate this:
 
Please Sign up or sign in to vote.
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 + "'"
Posted 10-Dec-12 1:33am
Comments
CHill60 10-Dec-12 8:33am
   
What is the error message that you get?
AndroidVivek 11-Dec-12 0:25am
   
there is nothing like getDate()...

this query is basically for windows (uses mysql)
and i am doing in android (sqlite)
in windows to get current date there is function like getDate()..
but i don't get such kind of functionality in andorid(sqlite)
AndroidVivek 11-Dec-12 0:54am
   
I dis one change and my query is now lil works

use datetime('now') instead getdate()..
thanks CHill60

1 solution

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

Solution 1

its instead of getTime() use

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

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
OriginalGriff 6,524
CHill60 3,490
Maciej Los 3,123
ppolymorphe 2,030
Jochen Arndt 1,975


Advertise | Privacy | Mobile
Web01 | 2.8.170525.1 | Last Updated 1 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

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