i use mysql to use datetime and it stores this

2008-06-15 05:49:08

i read it in from the database and parse it through

PHP Code:

function formatDate($val)
  {
      list($date, $time) = explode(" ", $val);
      list($year, $month, $day) = explode("-", $date);
      list($hour, $minute, $second) = explode (":", $time);
      return date("l, m.j.y @ H:ia", mktime($hour, $minute, $second, $month, $day, $year));
  } 


how do i get it to convert the datetime to another timezone in the php code.

The easiest way is to not use datetime.

Just use INT(11) and use time() as the value. You can then format that with the date() function.

From there, you can make a little function using mktime() or something to adjust for different timezones.

Thanks but I don't think that will work. Most of the code I'm using I got online and it works, I just would like to know how to change the datetime after it reads it in.

Im might also make it so they can pick their timezone.

http://www.google.com/search?q=php+timezone

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

2008-06-15 05:49:08 => you get
year = 2008
month = 06
day = 15 05:49:08

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

hour = 2008-06-15 05
minute = 49
second = 08

well... this is not ok

make a print_r to see your results and change some things

Try this:

<?
$timezone = -5;

echo gmdate("y/m/j H:i A", time() + 3600 * ($timezone + date("I")));

?>

This takes the timezone set in the variable (Eastern in this case) and adds or takes away the correct number of hours depending on the timezone. The finial part will adjust according to daylight savings time.

And why don't you use the date formatting functions of your db ?
Let the field in a datetime format, and use date_format(field_name,'format') in your query:
http://dev.mysql.com/doc/refman/5.0/...on_date-format

SELECT DATE_FORMAT('1900-10-04 22:23:00',
-> '%D %y %a %d %m %b %j');
-> '4th 00 Thu 04 10 Oct 277'

And if you want control over the timezone, then turn yourself to postgresql. It does support a "datetime with timezone" column type, which mysql simply don't do.
http://www.postgresql.org/docs/8.3/s...-datetime.html

I use yahoo webhosting for my website, and they have a mysql server I can use. That is why I cant change to the database you mentioned.

Ok, in that case, you have to handle the timezone in PHP, but I never done it before.

But for the date_format() function, it's a standard function that exists at least since mysql 3.0, so don't be afrais of using it.
It will be much easier than parsing a string in PHP, and more effective in terms of system resources.