Greg wrote:
Isn't the following date format supposed to work with any installation of
MySQL?
YYYY-MM-DD HH:NN:SS
It's not working on one system... the date is shown as all zero's.
Can you show example how to make it show all zeros? I would like to see
something like this (Except in my example the datetime seems to work fine):
mysql> create table datetimetest( col1 datetime );
Query OK, 0 rows affected (0.02 sec)
mysql> insert into datetimetest values( now() );
Query OK, 1 row affected (0.00 sec)
mysql> insert into datetimetest values( '2000-01-01 10:10:22' );
Query OK, 1 row affected (0.00 sec)
mysql> select * from datetimetest;
+---------------------+
| col1 |
+---------------------+
| 2004-07-30 19:59:38 |
| 2000-01-01 10:10:22 |
+---------------------+
2 rows in set (0.01 sec)