public void TestLiteral()
{
LiteralDateTime ldt = new LiteralDateTime("#2007-07-11 16:30:00#");
Assert.AreEqual("2007-07-11T16:30:00", ldt.Literal);
ldt = new LiteralDateTime("#2007-07-11 16:30:00#");
ldt.Delimiter = '#';
Assert.AreEqual("#2007-07-11 16:30:00#", ldt.Literal);
ldt = new LiteralDateTime("2007-07-11T16:30:00");
ldt.Delimiter = '#';
Assert.AreEqual("#2007-07-11 16:30:00#", ldt.Literal);
ldt = new LiteralDateTime("#2007-07-11 16:30:00#");
ldt.Delimiter = 'T';
Assert.AreEqual("2007-07-11T16:30:00", ldt.Literal);
ldt = new LiteralDateTime("2007-07-11 16:30:00");
ldt.Delimiter = 'T';
Assert.AreEqual("2007-07-11T16:30:00", ldt.Literal);
ldt = new LiteralDateTime("2007-07-11 16:30:00");
ldt.Delimiter = 't';
Assert.AreEqual("2007-07-11t16:30:00", ldt.Literal);
ldt = new LiteralDateTime(new StringValue("2007-07-11 16:30:00"));
Assert.AreEqual("TIMESTAMP '2007-07-11 16:30:00'", ldt.Literal);
ldt = new LiteralDateTime(new StringValue("2007-07-11 16:30:00"));
ldt.Delimiter = 't';
Assert.AreEqual("2007-07-11t16:30:00", ldt.Literal);
}
public void TestDateTime()
{
LiteralDateTime ldt = new LiteralDateTime("#2007-07-11 16:30:00#");
DateTime dt = ldt.DateTime;
Assert.AreEqual(2007, dt.Year);
Assert.AreEqual(7, dt.Month);
Assert.AreEqual(11, dt.Day);
Assert.AreEqual(16, dt.Hour);
Assert.AreEqual(30, dt.Minute);
Assert.AreEqual(0, dt.Second);
ldt = new LiteralDateTime("2007-07-11T16:30:00");
dt = ldt.DateTime;
Assert.AreEqual(2007, dt.Year);
Assert.AreEqual(7, dt.Month);
Assert.AreEqual(11, dt.Day);
Assert.AreEqual(16, dt.Hour);
Assert.AreEqual(30, dt.Minute);
Assert.AreEqual(0, dt.Second);
}