public void ToSqlString_WithNegativeOffset() { // Arrange var dateTime = new LocalDateTime(2012, 11, 24, 17, 45, 00); var offset = Offset.FromHoursAndMinutes(-12, -45); var offsetDateTime = new OffsetDateTime(dateTime, offset); // Act var sqlString = offsetDateTime.ToSqlString(); // Assert sqlString.Should().Be("2012-11-24 17:45:00-12:45"); }
public void ToSqlString_WithoutOffset() { // Arrange var dateTime = new LocalDateTime(2015, 12, 31, 23, 59, 59); var offset = Offset.Zero; var offsetDateTime = new OffsetDateTime(dateTime, offset); // Act var sqlString = offsetDateTime.ToSqlString(); // Assert sqlString.Should().Be("2015-12-31 23:59:59+00:00"); }
public void ToSqlString_WithPositiveOffset() { // Arrange var dateTime = new LocalDateTime(2013, 07, 17, 07, 20, 35); var offset = Offset.FromHours(7); var offsetDateTime = new OffsetDateTime(dateTime, offset); // Act var sqlString = offsetDateTime.ToSqlString(); // Assert sqlString.Should().Be("2013-07-17 07:20:35+07:00"); }