MySQL Forums
Forum List  »  InnoDB

Re: Query based on timestamp column
Posted by: Paul Jacob
Date: January 08, 2009 07:00PM

I have a table which has a column 'collectiontime' which store time stamps.Could any one suggest a query to pull last 24 hrs data from that table using time stamp?

Options: ReplyQuote


Subject
Views
Written By
Posted
19811
September 14, 2007 10:27PM
9590
September 16, 2007 10:23PM
8117
September 18, 2007 07:32AM
6924
September 27, 2007 02:02AM
Re: Query based on timestamp column
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.