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
Did you know?Explore Trending and Topic pages for more stories like this.
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

Convert Binary String to Decimal
Trying to Get:
Decimal: 305419896

Out of:
Binary String: xV4

i have no idea why this isn't working
Code: <?php
session_start();
include("connect.php");

error_reporting(E

Typedef struct vs just struct
Anyone know the rationale for using typedef for structs when a struct is itself a typedef? I have s

Gaining access to Drop Down Menu Variable
code is below, I am creating a drop down menu. I want to echo the value selected in the drop down me

Credit card verification
I have a client who wants to process credit card transactions from his web site rather than the goin

order by date not ID number help php
I am trying to orginize the following code to order by date not id number.
any help would be grea

fwrite error
Hi All,
Does anyone know what is causing the error in this code?

Code: <?
$error

How to refresh a parent page from a modal popup
Hi,I have a modal popup in which I need to upload a file and store in the database should give a mes

Image resize
Hi again fellers

I managed to sort out the issues with the folder,

Final hurdle is th

with clause
hi all, i have a big query that usually access the same table more than once. for example, i have s

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