time zone problems

[webgod]

Ok, i have a script that enters the date into a mysql database. I have a field named timestamp which is a datetime column type.

I insert the value with the now() function. The problem is my server is on eastern time and I'm in central time.

I know that I want to use the following for the parameters for date: M j Y, h:i a

I also know (or think I do) that the correct equation to subtract an hour would be this:
+(6060(-1))

However, that is where I am stuck. How do I convert $row->timestamp into the date above with the math for converting the time zone?

[Christian_B_]

Hi,

is it this?

// split the timestamp from the Database into date and time
list($date,$time) = explode(" ",$row->timestamp);

// split the date
list($year,$month,$day) = explode("-",$date);

// split the time
list($hour,$minute,$second) = explode(":",$time);

// make the UNIX-timestamp
$time_stamp =
mktime($hour,$minute,$second,$month,$day,$year);

// subtract 1 hour (= 3600 sec)
$time_stamp -= 3600;

// make the new Timestring
$new_time = date("M j Y, h:i a",$time_stamp);

echo $new_time;

Hope it works.

C.B.

[webgod]

Worked like a charm! Thanks!

[statrat]

why are you converting a timestamp to date back to timestamp back to date?

why not:

// make the new Timestring 
$new_time = date("M j Y, h:i a", $row->timestamp - 3600); 

echo $new_time; 

[webgod]

That would be nice, however, in pratice it changed all the times to:
Dec 31 1969, 06:00 pm

[statrat]

heh. sorry. guess i should've looked more closely. my bad.

[radbe]

How do I incorporate the above fix to the following code?
My time difference is roughly 2 hrs ahead my server
in other words the server's time is 6:00:24, my time is 8:00:02
Thanks for your help....

				   <?

				if ((!$day || !$year || $month) && !$mydate) {
				  	$mydate = date("Y-m-d");
				} else {
				 	$month = $month+1;
				 	if ($month && $year && $day) {
						$mydate = "$year-$month-$day";
					}
				}
				echo "<strong style='font-size: 13px;color:#666699;'>$mydate</strong><br /><br />";
				echo "<input type=\"hidden\" name=\"mode\" value=\"gowrite\">";
				echo "<input type=\"hidden\" name=\"mydate\" value=\"$mydate\">";

				$sql = "select * from notes where notes_date='$mydate' order by notes_time asc";
				$result = mysql_query($sql);
				while ($row=mysql_fetch_array($result)) {
					echo "
						<strong style='font-size: 11px;'>$row[notes_user]</strong> [".substr("$row[notes_time]", -8)."]<br />".nl2br(stripslashes($row[notes_note]))."<br /><br />
					";
				}
				mysql_free_result($result);
				 if ($mynotes && $user && $pass) {
					if ($allowhtml == "0") {
						$mynotes = str_replace("<", "&lt;", "$mynotes");
						$mynotes = str_replace(">", "&gt;", "$mynotes");
					}
					if ($mydate && $todayonly == "0") {
						$sql = "insert into notes (notes_date,notes_note,notes_time,notes_user) values ('$mydate','$mynotes',NOW(),'$user')";
					} else {
						$mydate = date("Y-m-d");
						$sql = "insert into notes (notes_date,notes_note,notes_time,notes_user) values ('$mydate','$mynotes',NOW(),'$user')";
					}

					while (list ($key, $val) = each ($allowed)) {
					    if ($key == "$user" && $val == "$pass") {
							mysql_query($sql) or die("error 324343");
						}
					}

					$adate = explode("-", $mydate);
					$mymonth = $adate[1]-1;
					header("Refresh:0;url=$PHP_SELF?day=$adate[2]&month=$mymonth&year=$adate[0]");
				}

				if ($todayonly == "1") {
					$posttext = "<strong style='font-size: 10px;color:#666699;'>Note: You can only post under today's date</strong>";
				} else {
					$posttext = "<strong style='font-size: 10px;color:#666699;'>Note: You can post notes under any date, past, present or future</strong>";
				}

			   ?>

[radbe]

See above post;

need assistance thanks

[radbe]

Someone!! Anyone!!
Just need a little help..

Thanks

[nemonoman]

I think you simply need to change NOW() to
NOW()+INTVERAL 2 HOUR

[radbe]

I was able to change the NOW() to NOW()-2000 or NOW+2000()
but when I try to go beyond that range it returns errors and 00:00:00 for time..

Cant seem to add anything esle but seconds unless I formatted the reference to hours incorrectly

[nemonoman]

If you actually use the code I provided:

NOW()-INTERVAL 2 HOUR

You should not experience these difficulties. That is why I suggested code that actually works, instead of code like NOW()-2000