TMyDataSetOptions.NullForZeroDate Property

Used for MySQL server to represent the value for for datetime fields with invalid values as Null or '0001-01-01' ('0100-01-01' for CLR).

Class

TMyDataSetOptions

Syntax

property NullForZeroDate: boolean default True;

Remarks

For datetime fields with invalid values, for example '2002-12-32', MySQL returns on fetch the '0000-00-00' value. According to the NullForZeroDate option this value will be represented as Null or '0001-01-01' ('0100-01-01' for CLR). The default value is True.