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