//-------------------------------------------------------------------//
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"));
}
