Re: Mysql date/time, was Re: Press Release -- Just

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