Hi team,
while inserting data from one table to another table. i am getting the below error.
SQL:
INSERT INTO dbo.Salesoffice_PLATFORM (DATENEW, USERNEW, ID, COUNTRYID, PLATFORMDESCRIPTION, PLATFORMGUID, VALIDFROM, VALIDTO) VALUES ('2020-09-01 13:12:41.06', 1589, '6EC029307AB11C4EB6D2FDE902F3EF34','20EA4D17A556514CA78287EBE9652ABC', 'Test' , '842BF8329EBE43ECAD890F50713AA988', '2014-07-22 22:00:00', '9999-12-31 23:00:00')
Error
[ODBC Driver 17 for SQL Server][SQL Server]The conversion of a datetime2 data type to a smalldatetime data type resulted in an out-of-range value.
Source table - Platform
- VALIDFROM datetime
- VALIDTO datetime
Destination table - salesOfficePlatform
VALIDFROM smalldatetime
VALIDTO smalldatetime
Is it possible to fix the issue without changing the datatype in the destination table. ?