DBA Dash Error for one of the data type

[DavidWiseman]

Discussed in #849

^{Originally posted by IndrajitMurgude March 29, 2024}
I am getting below error for one of the target server, I see these error in DBA Dash Errors (24 Hrs)
Microsoft.Data.SqlClient.SqlException (0x80131904): The conversion of a datetimeoffset data type to a datetime data type resulted in an out-of-range value.
I am unable to find for which data collection, this is happening and how this can be fixed.

Issue occurs in this collection. @LastMemoryDump is DATETIME and creation_time is DATETIMEOFFSET which has a larger range.

IF OBJECT_ID('sys.dm_server_memory_dumps') IS NOT NULL
BEGIN
	select @LastMemoryDump=MAX(creation_time),@DumpCount=COUNT(*) 
	from sys.dm_server_memory_dumps
END