Hi, But will the search be any faster using Integer or BigInt column type compared to using Date or DateTime columnd type.
Regards, --- Nitin <[EMAIL PROTECTED]> wrote: > no problems that i see..... > > ----- Original Message ----- > From: "p shah" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > 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/[EMAIL PROTECTED] > > > > __________________________________ 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/[EMAIL PROTECTED]