Conversion Error in transaction group

We are trying to store an ignition DateTime data type in an SQL table in a transaction group. The transaction group was set to create the table (ideally to prevent these types of errors) but the transaction still always fails to forward with the error “the conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value”. The date time values we are trying to store are: “Thu Jan 07 14:45:00 EST 2021”, “Thu Jan 07 14:45:30 EST 2021”, & “Thu Jan 07 14:46:00 EST 2021” so I don’t see what would result in an out of range value. How do we fix this error? In a different transaction group , writing to a different table, the value “Thu Jan 07 13:23:31 EST 2021” is written without error.