Date Formating Question

Anon

Hello All.

I have had the following code tucked in a file for months now, waiting to use it.

I finally find a need to use it, and I can't get it to work like I need.

First, the code that DOES work:

$HourOffSet = "3";
$TimeMethod = "Y-m-d g:i A";
$TimeReadjust = ($HourOffSet 60 60);
$MyTimeZoned = date($TimeMethod,time() + $TimeReadjust);
echo $MyTimeZoned;

In essance, it takes the present time and adds three hours to it ($HourOffSet)

Now, I am needing to take an existing date, from within a MySQL database, and have it change the date within the db.

The method I use to call my date (normally) is:

$row["added"]

So, now the code that I can't get to work.
This is the closest I've gotten, but it still isn't working.

$HourOffSet = "3";
$TimeMethod = "Y-m-d g:i A";
$TimeReadjust = ($HourOffSet 60 60);
$MyTimeZoned = date($TimeMethod,$row["added"] + $TimeReadjust);
echo $MyTimeZoned;

Can somebody please point out my error, and what I need to do to get it to print the date stored in the database PLUS the $HourOffSet.

Thanks.
JbA

(lastly, if anybody knows who wrote the above bit of code, can you please pass along their name & email for credit purposes!)

Anon

The first code you posted works fine on my php 4.0.2
What doesn't it do right?

By the way if you only need to select a date from a table and add 3 hours, why not use the mysql data manupulation functions?

Anon

Geesh, silly me...
ofcourse the first code works :-) giggle

Anyway, if you want to do date calculations on database values, it's usually better to let the database do it for you.

Anon

Hello Vincent.

I am just trying to add a little "time-zone" feature to my script.

I figured this would be the best method.

I don't know anything about that other method you suggested.

I am totally open to suggestions!

Thanks.
JbA

Anon

try:

SELECT DATE_ADD(your_date_field,INTERVAL 3 HOUR) AS new_date
FROM your_table;

Note: it really is "3 HOUR", there is no S after HOUR.

Anon

Wow, awesome Vincent!

You taught me something today, that's for sure!!

Many, many thanks!

JbA

Anon

Glad to be of help.

If you check out the mysql manual you will find even more very cool things you can do with queries.