Ben Clewett schrieb:
Hi Barry,
This is what I get:
mysql> CREATE TABLE a ( t TIMESTAMP );
Query OK, 0 rows affected (0.25 sec)
mysql> SELECT * FROM a WHERE t > '0001-01-01 00:00:00';
Empty set, 1 warning (0.00 sec)
mysql> SHOW WARNINGS;
+---------+------+-------------------------------------------------------------------------+
| Level | Code | Message |
+---------+------+-------------------------------------------------------------------------+
| Warning | 1292 | Incorrect datetime value: '0001-01-01 00:00:00' for
column 't' at row 1 |
+---------+------+-------------------------------------------------------------------------+
1 row in set (0.00 sec)
You can see MySQL complaining about the time format.
Although I am using .NET, I am not using any windows code. This is
MySQL on UNIX and .NET under Mono/Linux.
As I said, this warning is annoying. It falls on a bug in the .NET
MySQL library and causes it to crash nastily.
Personally it annoys me because this warning is a bit of a misnomer. I
am not assigning this value, only comparing to it...
(I know that TIMESTAMP has a far smaller date range than DATETIME. But
all our data has to be time-zone independent. Therefore TIMESTAMP is
the only field appropriate for our use.)
But this is not a 'religious' thing. We can easily code around it.
Until we hit a place we have forgotten this and crash Mono...
So, I am only asking nicely to any kind MySQL developer on this list,
please remove this warning :)
Well removing 'explicit' warinings for every user having problems with
3rd party modules would have mysql without any warnings nowadays ;)
i think that your mono should get more stable.
i'm also using an older version of mysql this might be the readon why i
don't get the arning. probably downgrade or well a path around might
work also.
I don't think any developer will remove that warning for that. ;)
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
