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

No comments posted yet

Your Answer:

Login to answer
216 Like 11 Dislike
Previous forums Next forums
Other forums

How do I use ValidatorCallout extender in Login control?
Hi,I'd like to customize the look and feel of the login control a little bit. One thing I'd love to

All possible combinations of Strings from table in PL/SQL
Hi,

I am trying to figure out how to build a list of all possible string combinations fro

Recognising Revenue daily
Hello.
Has anyone come across daily recognition of deferred income?
We want to implement R

removing space from the end of a variable
i have a variable $image which contains the following url "http://tiles.xbox.com/tiles/oo/P5/0m

Small problem with image resize script
Hi!

I am a little bit new to php and I have an issue installing an image resize script I down

Images in email problem
I found this script for sending emails, it works but if the email has <img src="image.jp

ctype() validation - allowing illegal characters
Hello,
I use ctype() to filter and validate a user form. However, I am trying to allow certain c

Storing Values taken from a DB...
Using this code it will generate a short list from my database

<?php
mysql_connect

mr8m - reverse document
Friends,

I'm trying to reverse a document held by MIRO, but it reports the message balan

PHP Thumbnail Creation
Ok so i use this function to create thumbnails:

Code: function createthumb($name,$filename,$n

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash