VulcanAnalytics / DBTester

Simplified MSSQL database testing library
GNU General Public License v3.0
1 stars 2 forks source link

Inserting data into date/time column fails #52

Closed darrencomeau closed 5 years ago

darrencomeau commented 5 years ago

image

        public void CreateObservation(int Id, int AerodromeId, string UnprocessedData, string Notes, DateTime UtcObservationTimestamp, int Source, DateTime UtcRecordTimestamp)
        {
            var columns = new string[] { "[Id]", "[AerodromeId]", "[Unprocessed Data]" , "[Notes]", "[UTC Timestamp Of Observation]", "[Observation Source Id]", "[UTC Timestamp Of Record]" };
            var record = new object[] { new object[] { Id, AerodromeId, UnprocessedData, Notes, UtcObservationTimestamp, Source, UtcRecordTimestamp } };

            CreateObservation(columns, record);
        }

        public void CreateObservation(string[] columns, object[] records)
        {
            database.InsertData("Weather", "Observation", columns, records);
        }
darrencomeau commented 5 years ago

Fixed - but if wanting to insert nanosecond precision into a datetime2 field you have to use VulcanAnalytics.DBTester.MsSqlDatabaseTester.DateTime2 instead of System.DateTime