New topic: How to Get Sql BETWEEN
<http://forums.realsoftware.com/viewtopic.php?t=46440> Page 1 of 1 [ 2 posts ] Previous topic | Next topic Author Message jetpr Post subject: How to Get Sql BETWEENPosted: Fri Jan 04, 2013 11:59 pm Joined: Wed Sep 20, 2006 5:12 pm Posts: 556 Location: Puerto Rico hello How i Get from BETWEEN two Date the number of day using sqlite (sql statements ) I need to get where Date have mode then 30 days _________________ Thanks for any contribution and God blesses all (I start Using RS in 10/12/2010) Mac Mini with Snow Leopard v10.6.8 and Real Studio 2012r1 Pro And Windows 7 RS2012r1 Personal and Linux RS2012r1 Personal Register user my Hobbies R/C Turbines Jets Models Top timhare Post subject: Re: How to Get Sql BETWEENPosted: Sat Jan 05, 2013 1:38 am Joined: Fri Jan 06, 2006 3:21 pm Posts: 11944 Location: Portland, OR USA Use the julianday function: where julianday(column1) - julianday(column2) > 30 Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 2 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
