Handling Date and Time Information in Connector/Net
Introduction
MySQL and the .NET languages handle date and time information differently, with MariaDB allowing dates that cannot be represented by a .NET data type, such as '0000-00-00 00:00:00'. These differences can cause problems if not properly handled.
The following sections demonstrate how to properly handle date and time information when using Connector/Net.