From: Date: December 3 2003 7:53am
Subject: Mysql Date column type
List-Archive: http://lists.mysql.com/mysql/154919
Message-Id: <20031203065347.87992.qmail@web40711.mail.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

Hi,

I have one question regarding date column type in
MYSQL.

Can I use the column type for date as Integer instead
of DateTime or Date to store the date as
yyyymmddhhmmss or yyyymmdd?

As I know MYSQL accepts this format. But I am not too
sure about the column type.

What are the pros and cons for using Integer column
type for the date?

Please reply at the earliest.

Regards,


__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/