MySQL Forums
Forum List  »  InnoDB

Re: Query based on timestamp column
Posted by: JinRong Ye
Date: September 16, 2007 10:23PM

firstly,the index on column `date` is needed.
secondly,you can convert the column `date` to int unsigned type,and replace the values by UNIX TIMESTAMP,such as 1190002964 represent '2007-09-17 12:22:44'

MySQL 中文网 http://imysql.cn

Options: ReplyQuote


Subject
Views
Written By
Posted
19811
September 14, 2007 10:27PM
Re: Query based on timestamp column
9589
September 16, 2007 10:23PM
8117
September 18, 2007 07:32AM
6924
September 27, 2007 02:02AM
5209
January 08, 2009 07:00PM
6245
January 16, 2009 12:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.