Adding 10 hours

Brusca

Howdy,
Not sure exactly where to post this but here goes.

I am SELECTING a timestamp called 'blog_date' from blog.

Like this:

SELECT DATE_FORMAT(blog_date, '%a %D %b %H:%i %p') AS new_date FROM blog;

This displays great.
Fri 19th Sep 10:58 AM

But I now need to add an INTERVAL of 10 HOURS.

I have tried using DATE_ADD and DATE_SUB. But to no avail.

Anyone have any clues?

Moonglobe

find a way using PHP outside of the DB? like using [man]intval[/man], [man]strpos[/man], [man]substr[/man]and other functions to manipulate the date.

hth
moon 🙂

LordShryku

Right, you're going to want to not format it with SQL, so then you get just the timestamp(which you really do need the year), and you can use something like this

$datePlusTen = date("D jS M h:i A", (strtotime($date)+36000));

Moonglobe

heh, there's always that 😃

Brusca

Sorry for the silly questions but I am still getting my head round this stuff.

Can you show me how to implement this from my SELECT statement down to the php code.

My column 'blog_date' holds datetime statement like this 2003-09-19 10:58:41.

Cheers Bruce

LordShryku

Originally posted by Moonglobe
heh, there's always that 😃

uh huh, as always, RTFM
http://www.php.net/manual/en/ref.datetime.php

LordShryku

$sql = mysql_query("SELECT blog_date AS new_date FROM blog");
while($row=mysql_fetch_array($sql)) {
    $datePlusTen = date("D jS M h:i A", strtotime($row['new_date'])+36000);
    // 36000 is 10 hours in seconds
}