Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 16th, 2012  |  syntax: None  |  size: 1.48 KB  |  hits: 10  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. SQLlite query for getting data BETWEEN 2 dates not working
  2. SELECT * FROM trip_mark WHERE file_type = 2
  3. AND create_time BETWEEN date('2011-11-08 00:00:00') AND date('2011-11-10 00:00:00')
  4.        
  5. CREATE TABLE `trip_mark` (
  6. `file_id` INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL,
  7. `local_path` varchar(100) DEFAULT NULL ,
  8. `file_type` int(11) DEFAULT NULL,
  9. `import_date` datetime DEFAULT NULL ,
  10. `create_time` datetime DEFAULT NULL ,
  11. `isSyncAvailable` int(11) DEFAULT '1' ,
  12. `syncDate` datetime DEFAULT NULL ,
  13. `isSynced` int(11) DEFAULT '0' ,
  14. `longitude` float DEFAULT NULL ,
  15. `altitude` float DEFAULT NULL ,
  16. `place_logical_name` varchar(150) DEFAULT NULL ,
  17. `file_note` varchar(250) DEFAULT NULL )
  18.        
  19. "1","/sdcard/TripMark_1323375027.jpg","2","2011-11-09 01:10:37","2011-11-09 01:10:37","1","null","0","-1","-1","Unknown Location","");
  20. "2","/sdcard/TripMark_1323375053.jpg","2","2011-02-09 01:11:01","2011-02-09 01:11:01","1","null","0","-1","-1","Unknown Location","");
  21. "3","/sdcard/TripMark_1323375260.jpg","2","2011-11-09 01:14:29","2011-11-09 01:14:29","1","null","0","-1","-1","Unknown Location","sdfas");
  22.        
  23. SELECT * FROM trip_mark WHERE file_type = 2
  24. AND create_time BETWEEN date('2011-11-08 00:00:00') AND date('2011-11-10 00:00:00')
  25.        
  26. "1","/sdcard/TripMark_1323375027.jpg","2","2011-11-09 01:10:37","2011-11-09 01:10:37","1","null","0","-1","-1","Unknown Location",""
  27. "3","/sdcard/TripMark_1323375260.jpg","2","2011-11-09 01:14:29","2011-11-09 01:14:29","1","null","0","-1","-1","Unknown Location","sdfas"
create a new version of this paste RAW Paste Data