public void TIME_HighResolution_Data_ScriptsCorrectly()
{
TimeSpan baseData = new TimeSpan(TimeSpan.TicksPerHour * 2 + TimeSpan.TicksPerMinute * 33 + TimeSpan.TicksPerSecond * 44 + 1234567);
object data = baseData;
var fieldInfo = SchemaScriptingTests.FakeColumn("test", "test", 32, "time", false, 0, 0);
Assert.AreEqual("'02:33:44.1234567'", FieldScripting.valueAsTSQLLiteral(data, fieldInfo), "time fractional seconds");
Assert.AreEqual("02:33:44.1234567", FieldScripting.formatTime(data, false), "time fractional seconds");
}
public void TIME_LowResolution_Data_ScriptsCorrectly()
{
TimeSpan baseData = new TimeSpan(0, 2, 33, 44);
object data = baseData;
var fieldInfo = SchemaScriptingTests.FakeColumn("test", "test", 32, "time", false, 0, 0);
Assert.AreEqual("'02:33:44'", FieldScripting.valueAsTSQLLiteral(data, fieldInfo), "time no fractional seconds");
Assert.AreEqual("02:33:44", FieldScripting.formatTime(data, false), "time no fractional seconds");
baseData = new TimeSpan(0, 2, 33, 44, 100);
data = baseData;
Assert.AreEqual("'02:33:44.1'", FieldScripting.valueAsTSQLLiteral(data, fieldInfo), "time partial fractional seconds");
Assert.AreEqual("02:33:44.1", FieldScripting.formatTime(data, false), "time partial fractional seconds");
baseData = new TimeSpan(0, 2, 33, 44, 123);
data = baseData;
Assert.AreEqual("'02:33:44.123'", FieldScripting.valueAsTSQLLiteral(data, fieldInfo), "time fractional seconds");
Assert.AreEqual("02:33:44.123", FieldScripting.formatTime(data, false), "time fractional seconds");
}
public void TIME_HighResolution_Data_ScriptsCorrectly()
{
DateTime baseData = new DateTime(1900, 1, 1, 2, 33, 44);
object data = baseData;
var fieldInfo = SchemaScriptingTests.FakeColumn("test", "test", 32, "time", false, 0, 0);
Assert.AreEqual("'02:33:44'", FieldScripting.valueAsTSQLLiteral(data, fieldInfo), "time no fractional seconds");
Assert.AreEqual("02:33:44", FieldScripting.formatTime(data, false), "time no fractional seconds");
baseData = new DateTime(1900, 1, 1, 2, 33, 44).AddMilliseconds(100);
data = baseData;
Assert.AreEqual("'02:33:44.1'", FieldScripting.valueAsTSQLLiteral(data, fieldInfo), "partial fractional seconds");
Assert.AreEqual("02:33:44.1", FieldScripting.formatTime(data, false), "partial fractional seconds");
baseData = new DateTime(1900, 1, 1, 2, 33, 44).AddTicks(1234567);
data = baseData;
Assert.AreEqual("'02:33:44.1234567'", FieldScripting.valueAsTSQLLiteral(data, fieldInfo), "time fractional seconds");
Assert.AreEqual("02:33:44.1234567", FieldScripting.formatTime(data, false), "time fractional seconds");
}
