Statistics
| Revision:

svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.plugin / org.gvsig.h2spatial / org.gvsig.h2spatial.h2gis132 / org.gvsig.h2spatial.h2gis132.provider / src / test / resources / org / gvsig / fmap / dal / store / h2 / date.sql @ 46106

History | View | Annotate | Download (448 Bytes)

1 

    		
  

  

    
      2
    
    
      
-- Date SQL


    		
  

  

    
      3
    
    
      

    		
  

  

    
      4
    
    
      
-- Simple


    		
  

  

    
      5
    
    
      
SELECT 


    		
  

  

    
      6
    
    
      
    "ID", "Byte", "Bool1", "Long", "Timestamp", "Date", "Time", "Bool2", 


    		
  

  

    
      7
    
    
      
    "String", "Bool3", "Double", "Bool4", "Float", "Bool5", "Decimal", 


    		
  

  

    
      8
    
    
      
    NVL2("Geometry",ST_AsBinary("Geometry"),NULL) 


    		
  

  

    
      9
    
    
      
  FROM "PUBLIC"."test" 


    		
  

  

    
      10
    
    
      
  WHERE ((


    		
  

  

    
      11
    
    
      
    ("Time" > TIME '01:02:03') AND 


    		
  

  

    
      12
    
    
      
    ("Time" < TIME '20:52:55')


    		
  

  

    
      13
    
    
      
    ) OR (


    		
  

  

    
      14
    
    
      
    ("Date" > DATE '2019-02-17') AND 


    		
  

  

    
      15
    
    
      
    ("Date" < DATE '2020-02-23')


    		
  

  

    
      16
    
    
      
  )) ORDER BY "ID" ASC NULLS LAST;