[EMAIL PROTECTED] wrote:
>
> Oh, and mySQL's date handling is far, far superior to SQL Server's. It's on a whole
> other level.
I hope you were being cynical. But just to make sure everybody
understands how hopelessly evil date handling in MySQL is:
> mysql> create table test (a date);
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> insert into test values (-1);
> Query OK, 1 row affected (0.01 sec)
>
> mysql> insert into test values ('1996-02-31');
> Query OK, 1 row affected (0.00 sec)
>
> mysql> insert into test values ('1996-67-31');
> Query OK, 1 row affected (0.00 sec)
>
> mysql> select * from test;
> +------------+
> | a |
> +------------+
> | 0000-00-00 |
> | 1996-02-31 |
> | 0000-00-00 |
> +------------+
> 3 rows in set (0.00 sec)
That is indeed a whole other level.
Jochem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
