From: Date: December 3 2003 6:25pm
Subject: Re: Mysql Date column type
List-Archive: http://lists.mysql.com/mysql/154965
Message-Id: <20031203172532.34868.qmail@web40709.mail.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

Hi,

But will the search be any faster using Integer or
BigInt column type compared to using Date or DateTime
columnd type.

Regards,
 
--- Nitin <nitinmehta@stripped> wrote:
> no problems that i see.....
> 
> ----- Original Message ----- 
> From: "p shah" <piyushinfo@stripped>
> To: <mysql@stripped>
> Sent: Wednesday, December 03, 2003 12:23 PM
> Subject: Mysql Date column type
> 
> 
> > 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/
> >
> > -- 
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
>
http://lists.mysql.com/mysql?unsub=nitinmehta@stripped
> >
> 
> 


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