[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Date problem
From:       Kole Dunn <kole () arialnet ! net>
Date:       2000-02-01 15:10:38
[Download RAW message or body]

Hi all,
I have a date column that displays 2001-00-21 instead of 2000-2-1. 
Yesterday, it showed the year as 2010. Anyone know what's going on?
The date is correct on my machine. Here is the results of SHOW FIELDS...

+---------+--------------+------+-----+---------+----------------+
| Field   | Type         | Null | Key | Default | Extra          |
+---------+--------------+------+-----+---------+----------------+
| qty     | varchar(15)  | YES  |     | NULL    |                |
| sku     | varchar(20)  | YES  |     | NULL    |                |
| product | varchar(50)  | YES  |     | NULL    |                |
| price   | decimal(9,2) | YES  |     | NULL    |                |
| sub     | decimal(9,2) | YES  |     | NULL    |                |
| date    | date         | YES  |     | NULL    |                |
| uid     | varchar(15)  | YES  |     | NULL    |                |
| id      | int(11)      |      | PRI | 0       | auto_increment |
+---------+--------------+------+-----+---------+----------------+


KD

-- 
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread26120@lists.mysql.com

To unsubscribe, send a message to:
    <mysql-unsubscribe-mysql=progressive-comp.com@lists.mysql.com>

[prev in list] [next in list] [prev in thread] [next in thread]