Click here to Skip to main content
Rate this: bad
good
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 at 10-Dec-12 8:33am
   
What is the error message that you get?
AndroidVivek at 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 at 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
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 462
1 sanket saxena 355
2 OriginalGriff 235
3 Abhinav S 233
4 CPallini 205
0 Sergey Alexandrovich Kryukov 8,784
1 OriginalGriff 5,025
2 Peter Leow 3,839
3 Maciej Los 3,535
4 Er. Puneet Goel 3,107


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