//-------------------------------------------------------------------// private static object ExcelDateArray2QTimestamp(Array a) { var dim1 = a.GetLength(0); if (a.Rank == 1) { var res = new QTimestamp[dim1]; for (var i = 0; i < dim1; i++) { res[i] = (QTimestamp)ExcelDate2QTimestamp(a.GetValue(i)); } return(res); } var dim2 = a.GetLength(1); var r = new object[dim2]; //two dimensional array for (var i = 0; i < dim2; i++) { var elem = new QTimestamp[dim1]; for (var j = 0; j < dim1; j++) { elem[j] = (QTimestamp)ExcelDate2QTimestamp(a.GetValue(j, i)); } r[i] = elem; } return(r); }
public void testQTimestampFromString() { Assert.AreEqual(new QTimestamp(-142079387000000000L), QTimestamp.FromString("1995.07.01D13:30:13.000000000")); Assert.AreEqual(new QTimestamp(-31449601000000000L), QTimestamp.FromString("1999.01.01D23:59:59.000000000")); Assert.AreEqual(new QTimestamp(0L), QTimestamp.FromString("2000.01.01D00:00:00.000000000")); Assert.AreEqual(new QTimestamp(173498399000000012L), QTimestamp.FromString("2005.07.01D01:59:59.000000012")); Assert.AreEqual(new QTimestamp(315671022000000066L), QTimestamp.FromString("2010.01.01D14:23:42.000000066")); Assert.AreEqual(new QTimestamp(long.MinValue), QTimestamp.FromString(null)); Assert.AreEqual(new QTimestamp(long.MinValue), QTimestamp.FromString("")); Assert.AreEqual(new QTimestamp(long.MinValue), QTimestamp.FromString("0Np")); }