In this post, you’ll learn about the SQL error code 542 in InterSystems IRIS database the reason why you are receiving the TSQL message when using the InterSystems IRIS data platform
Error Code :
542
Reason for the Error code 542 in InterSystems IRIS DBMS
An invalid datetime value was encountered. Value exceeds the year 9999.