BHoM / BHoM/SQL_Toolkit

Values for DateTime properties below SQLDateTime.MinValue cause errors on push

Open
#30 0 comments 0 reactions 1 assignee Claimed by @adecler View on GitHub
type:bug
Dominant language
C#
Stars
1
Forks
1
PR merge metrics
No merged PRs in 30d

Description

#### Description:
When pushing any objects with a DateTime property set to DateTime.MinValue or any value before the SQLDateTime.MinValue of 1/1/1753, the push fails as the DateTime can not be sent to the DB. We should add handling to check for values below the SQL MinValue, and set them to the SQL MinValue accordingly.

#### Steps to reproduce:
Send object with a DateTime property set to earlier than 1753 to a SQL table for the corresponding object type.

#### Expected behaviour:
Successful push of the object, with the date set to the SQL MinValue.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.