From 3739de6df80d0b20310c3c9d0fcab133fc734b0e Mon Sep 17 00:00:00 2001 From: James Ahlborn Date: Thu, 26 Jul 2018 20:22:13 +0000 Subject: test TimeSerial; implement DateSerial git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1187 f203690c-595d-4dc9-a70b-905162fa7fd2 --- .../jackcess/impl/expr/DefaultFunctionsTest.java | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'src/test') 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 8248c08..ca1a67c 100644 --- a/src/test/java/com/healthmarketscience/jackcess/impl/expr/DefaultFunctionsTest.java +++ b/src/test/java/com/healthmarketscience/jackcess/impl/expr/DefaultFunctionsTest.java @@ -237,6 +237,15 @@ public class DefaultFunctionsTest extends TestCase assertEquals("3:57:34 AM", eval("=CStr(TimeSerial(3,57,34))")); assertEquals("3:57:34 PM", eval("=CStr(TimeSerial(15,57,34))")); + assertEquals("5:45:00 AM", eval("=CStr(TimeSerial(6,-15,0))")); + assertEquals("12:00:00 AM", eval("=CStr(TimeSerial(0,0,0))")); + assertEquals("2:00:00 PM", eval("=CStr(TimeSerial(-10,0,0))")); + assertEquals("6:00:00 AM", eval("=CStr(TimeSerial(30,0,0))")); + + assertEquals("2/12/1969", eval("=CStr(DateSerial(69,2,12))")); + assertEquals("2/12/2010", eval("=CStr(DateSerial(10,2,12))")); + assertEquals("7/12/2013", eval("=CStr(DateSerial(2014,-5,12))")); + assertEquals("8/7/2013", eval("=CStr(DateSerial(2014,-5,38))")); } public void testFinancialFuncs() throws Exception -- cgit v1.2.3