Statistics
| Revision:

svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.plugin / org.gvsig.sqlite / org.gvsig.sqlite.provider / src / test / resources / org / gvsig / sqlite / dal / date.sql @ 47539

History | View | Annotate | Download (778 Bytes)

1 

    		
  

  

    
      2
    
    
      
-- Date SQL


    		
  

  

    
      3
    
    
      

    		
  

  

    
      4
    
    
      
-- Simple


    		
  

  

    
      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" 


    		
  

  

    
      12
    
    
      
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;