On Wednesday 20 Nov 2002 2:02 pm, Jason Hihn wrote:
> Oh, that is interesting... But that is not a datetime.
Doh - operating a keyboard without engaging the brain first.
mysql> insert into foo2 values (1,now());
mysql> insert into foo2 values (2,'');
mysql> insert into foo2 values (3,'asdf');
mysql> select * from foo2;
+------+---------------------+
| a | b |
+------+---------------------+
| 1 | 2002-11-20 15:07:54 |
| 2 | 0000-00-00 00:00:00 |
| 3 | 0000-00-00 00:00:00 |
+------+---------------------+
--
Richard Huxton