Revision 47579 trunk/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.sqlite/org.gvsig.sqlite.provider/src/test/resources/org/gvsig/sqlite/dal/date.sql

View differences:

date.sql
3 3 

  		




  4
  4
  
    
-- Simple


  		




  5
  5
  
    
SELECT 


  		




  6
  
  
    
    "PUBLIC"."test"."ID", "PUBLIC"."test"."Byte", "PUBLIC"."test"."Bool1", "PUBLIC"."test"."Long", 


  		




  7
  
  
    
    "PUBLIC"."test"."Timestamp", "PUBLIC"."test"."Date", "PUBLIC"."test"."Time", "PUBLIC"."test"."Bool2", 


  		




  8
  
  
    
    "PUBLIC"."test"."String", "PUBLIC"."test"."Bool3", "PUBLIC"."test"."Double", "PUBLIC"."test"."Bool4", 


  		




  9
  
  
    
    "PUBLIC"."test"."Float", "PUBLIC"."test"."Bool5", "PUBLIC"."test"."Decimal", 


  		




  10
  
  
    
    NVL2("PUBLIC"."test"."Geometry",ST_AsBinary("PUBLIC"."test"."Geometry"),NULL) 


  		




  11
  
  
    
FROM "PUBLIC"."test" 


  		




  
  6
  
    
    "test"."ID", "test"."Byte", "test"."Bool1", "test"."Long", 


  		




  
  7
  
    
    "test"."Timestamp", "test"."Date", "test"."Time", "test"."Bool2", 


  		




  
  8
  
    
    "test"."String", "test"."Bool3", "test"."Double", "test"."Bool4", 


  		




  
  9
  
    
    "test"."Float", "test"."Bool5", "test"."Decimal", "test"."Geometry" 


  		




  
  10
  
    
FROM "test" 


  		




  12
  11
  
    
WHERE 


  		




  13
  
  
    
    ((("PUBLIC"."test"."Time" > TIME '01:02:03') AND ("PUBLIC"."test"."Time" < TIME '20:52:55')) OR 


  		




  14
  
  
    
    (("PUBLIC"."test"."Date" > DATE '2019-02-17') AND ("PUBLIC"."test"."Date" < DATE '2020-02-23'))) 


  		




  15
  
  
    
ORDER BY "PUBLIC"."test"."ID" ASC;


  		




  
  12
  
    
    ((("test"."Time" > ('01:02:03')) AND ("test"."Time" < ('20:52:55'))) OR 


  		




  
  13
  
    
    (("test"."Date" > ('2019-02-17')) AND ("test"."Date" < ('2020-02-23')))) 


  		




  
  14
  
    
ORDER BY "test"."ID" ASC;


  		












Also available in:  Unified diff