To whom it may concern,
I'm involved in lots of C# coding with several coders.
I have a gripe with MySQL which may be easy to solve in future development.
C# has two DateTime constants:
DateTime.MinValue = '0001-01-01 00:00:00.000'
DateTime.MaxValue = '9999-12-31 23:59:59.999'
These are very useful to denote a date always beyond some data, or a
date always before some data.
Further, C# does not let you set DateTime to NULL. (very annoying!)
These values therefore tend to creep into code where NULL would be
better used.
MySQL really doesn't like these values, it shows warnings:
+---------+------+-------------------------------------------------+
| Level | Code | Message |
+---------+------+-------------------------------------------------+
| Warning | 1292 | Incorrect datetime value: '0001-01-01 00:00:00' |
+---------+------+-------------------------------------------------+
The real problem with these warning is:
1. This date is legal, if a little unlikely.
2. Any warning crash MySql.Data.dll!!!
If there is a kindly developer watching these mailing lists, can I
suggest MySQL accepts these values, at least for comparisons, a little
cleaner?
For what it's worth, and to help us C# coders...
Ben
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
