mysql 3.23 datatime problem

External Since: Dec 15, 2004 Posts: 1

Hi all,

I am inserting datatime value into mysql table, while select value its
giving 0000-00-00 00:00:00 value.

mysql> insert into dtest values('02-17-05 17:08:02');
Query OK, 1 row affected (0.00 sec)

mysql> select * from dtest;

+---------------------+
| mydate |
+---------------------+
| 0000-00-00 00:00:00 |
+---------------------+
1 row in set (0.00 sec)

mysql> desc dtest;
+--------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+----------+------+-----+---------+-------+
| mydate | datetime | YES | | NULL | |
+--------+----------+------+-----+---------+-------+
1 row in set (0.00 sec)

Any help to fix this problem.

-SR

External Since: Jun 17, 2004 Posts: 42

Sun wrote:
> mysql> insert into dtest values('02-17-05 17:08:02');

Try '2005-02-17 17:08:02'. MySQL accepts date formats only in one
format, YYYY-MM-DD.

Regards,
Bill K.