6.12 Handling Date and Time Information in Connector/Net

6.12.1 Fractional Seconds
6.12.2 Problems when Using Invalid Dates
6.12.3 Restricting Invalid Dates
6.12.4 Handling Invalid Dates
6.12.5 Handling NULL Dates

MySQL and the .NET languages handle date and time information differently, with MySQL 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.