MySQL Forums :: PHP :: Date - unix_timestamp


Advanced Search

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.

Thanks

Options: ReplyQuote


Subject Written By Posted
Date - unix_timestamp Beauford Beauford 02/04/2010 02:38PM
Re: Date - unix_timestamp Rick James 02/06/2010 12:27AM
Re: Date - unix_timestamp Beauford Beauford 02/07/2010 11:33AM
Re: Date - unix_timestamp Rick James 02/07/2010 12:13PM
Re: Date - unix_timestamp Beauford Beauford 02/07/2010 09:21PM
Re: Date - unix_timestamp Rick James 02/07/2010 09:43PM
Re: Date - unix_timestamp Beauford Beauford 02/07/2010 10:16PM
Re: Date - unix_timestamp Rick James 02/07/2010 10:22PM
Re: Date - unix_timestamp Beauford Beauford 02/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.