Re: Mysql Date column type

[p shah]

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=1
> >
> 
> 


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