Revision 44951 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

View differences:

date.sql
3 3 

  		




  4
  4
  
    
-- Simple


  		




  5
  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" 


  		




  
  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
  10
  
    
  WHERE ((


  		




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


  		




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


  		




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


  		




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


  		




  13
  13
  
    
    ) OR (


  		




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


  		




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


  		




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


  		




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


  		




  16
  16
  
    
  ));


  		












Also available in:  Unified diff