mysql timestamp manipulation

Posted on 16th Feb 2014 07:03 pm by admin

How could I use a timestamp (e.g 2009-10-30 13:20:35 ), and with php find out if it is:

from today
from this week
from this month
from the last 3 months
from the last 6 months
from this year
from 1 year ago
etc etc

?

Thanks

Your Answer:

Login to answer

Other forums

How to grab certain words ??
I am working with this API

Returns JSON.
curl http://letsbetrends.com/api/current_trends

How could I do this?
Ive got a simple lottery game, and am using an sql database to keep track of the numbers bought. But

Agency Business Process
Hi,

I don’t understand the process of the agency business in SAP.

In my

Mail from PHP form not always ending up in my inbox?
Hi guys,

I'm a real newbie to PHP and have managed to put together a simple mail form that se

HTML Email rec'd as Source Code
The code does create and send the email successfully. However, the message shows as html code and n

please help me... my password gets encrypted but not able to get in database
hai guys,
please help me... in the following function my password gets encrypted but no

How to make a mail Form secure?
I want to create an email Form on my web site. How can I make the Form secure so the submitted info

Save User Inputs while javascript reloading!
hi..
i have written a PHP code in which i reload the page when user selects a value in dropdown..

how to remove in php string display
My code is $message="We're looking at developing our website."; $body= "My mess

Unable to customise toolbar in FCK