add more type coercion, string and date to num

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1084 f203690c-595d-4dc9-a70b-905162fa7fd2

1 files changed, 10 insertions, 0 deletions

diff --git a/src/main/java/com/healthmarketscience/jackcess/expr/Value.java b/src/main/java/com/healthmarketscience/jackcess/expr/Value.java
index 04844ae..ad0e587 100644
--- a/src/main/java/com/healthmarketscience/jackcess/expr/Value.java
+++ b/src/main/java/com/healthmarketscience/jackcess/expr/Value.java
@@ -46,6 +46,16 @@ public interface Value
       return((ordinal() <= DOUBLE.ordinal()) ? DOUBLE : BIG_DEC);
     }
 
+    public Type getPreferredNumericType() {
+      if(isNumeric()) {
+        return this;
+      }
+      if(isTemporal()) {
+        return ((this == DATE) ? LONG : DOUBLE);
+      }
+      return null;
+    }
+
     private boolean inRange(Type start, Type end) {
       return ((start.ordinal() <= ordinal()) && (ordinal() <= end.ordinal()));
     }