MySQL Forums
Forum List  »  InnoDB

Re: Query based on timestamp column
Posted by: Rick James
Date: January 16, 2009 12:18AM

Rummage around in the available date functions: NOW(), FROM_UNIXTIMESTAMP(), UNIX_TIMESTAMP(), DATE_SUB(), and (if you have converted to seconds) -24*60*60.

Options: ReplyQuote


Subject
Views
Written By
Posted
19821
September 14, 2007 10:27PM
9596
September 16, 2007 10:23PM
8120
September 18, 2007 07:32AM
6927
September 27, 2007 02:02AM
5212
January 08, 2009 07:00PM
Re: Query based on timestamp column
6246
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.