MySQL Forums
Forum List  »  PHP

Date - unix_timestamp
Posted by: Beauford Beauford
Date: February 04, 2010 02:38PM

I save my dates in MySQL as unix_timstamp and I need a way to be able to search the table for all entries in a certain month.

So if I want to find out how many users signed up in Jan, or Feb I can find that out. I have searched all over again but can't find anything.

I'm sure there has to be a way to just extract the month and year from a unix timestamp.

I have tried to read and understand all the different date functions, but they might as well be written in Martian.


Options: ReplyQuote

Written By
Date - unix_timestamp
February 04, 2010 02:38PM
February 06, 2010 12:27AM
February 07, 2010 11:33AM
February 07, 2010 12:13PM
February 07, 2010 09:21PM
February 07, 2010 09:43PM
February 07, 2010 10:16PM
February 07, 2010 10:22PM
February 07, 2010 10:31PM

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.