Statistics
| Revision:

svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.compat.cdc / org.gvsig.fmap.dal / org.gvsig.fmap.dal.db / org.gvsig.fmap.dal.db.mdb / src / test / resources / org / gvsig / fmap / dal / store / mdb / date.sql @ 44951

History | View | Annotate | Download (392 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
    
    
      
    [Geometry], [Decimal19_0] 


    		
  

  

    
      9
    
    
      
  FROM [test] 


    		
  

  

    
      10
    
    
      
  WHERE ((


    		
  

  

    
      11
    
    
      
    ([Time] > #01:02:03#) AND 


    		
  

  

    
      12
    
    
      
    ([Time] < #20:52:55#)


    		
  

  

    
      13
    
    
      
    ) OR (


    		
  

  

    
      14
    
    
      
    ([Date] > DATEVALUE('2019-02-17')) AND 


    		
  

  

    
      15
    
    
      
    ([Date] < DATEVALUE('2020-02-23'))


    		
  

  

    
      16
    
    
      
  ));