This property determines whether Date and DateTime values consisting entirely of zeros (for example, '0000-00-00' or '0000-00-00 00:00:00') are returned as NULL values. By default, this property is set to 'true', meaning any invalid date or datetime values represented as all zeros is returned as NULL instead of their original value.

Data Type

bool

Default Value

true

Remarks

This property addresses how MySQL handles invalid Date or DateTime values, where a value of all zeros (for example, '0000-00-00' or '0000-00-00 00:00:00') is considered invalid. Retrieving such a value can result in parsing errors or unexpected behavior unless this property is set to 'true', in which case the system returns NULL instead.

If set to 'false', the system returns the original value of the invalid Date or DateTime as it is, which may cause parsing errors or inconsistencies during further processing.