diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/java/com/healthmarketscience/jackcess/PropertyExpressionTest.java | 1 | ||||
| -rw-r--r-- | src/test/java/com/healthmarketscience/jackcess/impl/expr/DefaultFunctionsTest.java | 8 |
2 files changed, 9 insertions, 0 deletions
diff --git a/src/test/java/com/healthmarketscience/jackcess/PropertyExpressionTest.java b/src/test/java/com/healthmarketscience/jackcess/PropertyExpressionTest.java index ffb2dd3..384386e 100644 --- a/src/test/java/com/healthmarketscience/jackcess/PropertyExpressionTest.java +++ b/src/test/java/com/healthmarketscience/jackcess/PropertyExpressionTest.java @@ -295,6 +295,7 @@ public class PropertyExpressionTest extends TestCase public static void testCustomEvalConfig() throws Exception { TemporalConfig tempConf = new TemporalConfig("yyyy/M/d", "M/d", + "yyyy-MMM-d", "hh.mm.ss a", "HH.mm.ss", '/', '.', Locale.US); diff --git a/src/test/java/com/healthmarketscience/jackcess/impl/expr/DefaultFunctionsTest.java b/src/test/java/com/healthmarketscience/jackcess/impl/expr/DefaultFunctionsTest.java index f40a1de..fdab104 100644 --- a/src/test/java/com/healthmarketscience/jackcess/impl/expr/DefaultFunctionsTest.java +++ b/src/test/java/com/healthmarketscience/jackcess/impl/expr/DefaultFunctionsTest.java @@ -253,6 +253,14 @@ public class DefaultFunctionsTest extends TestCase assertEval("($12.34)", "=FormatCurrency(-12.345,-1,True,True)"); assertEval("$12", "=FormatCurrency(12.345,0,True,True)"); assertEval("-$.123", "=FormatCurrency(-0.12345,3,False)"); + + assertEval("1/1/1973 1:37:25 PM", "=FormatDateTime(#1/1/1973 1:37:25 PM#)"); + assertEval("1:37:25 PM", "=FormatDateTime(#1:37:25 PM#,0)"); + assertEval("1/1/1973", "=FormatDateTime(#1/1/1973#,0)"); + assertEval("Monday, January 01, 1973", "=FormatDateTime(#1/1/1973 1:37:25 PM#,1)"); + assertEval("1/1/1973", "=FormatDateTime(#1/1/1973 1:37:25 PM#,2)"); + assertEval("1:37:25 PM", "=FormatDateTime(#1/1/1973 1:37:25 PM#,3)"); + assertEval("13:37", "=FormatDateTime(#1/1/1973 1:37:25 PM#,4)"); } public void testNumberFuncs() throws Exception |