MySql timezone

[eugene2009]

$sql = "SELECT *, date_format(date, '%m/%d/%Y at %I:%i %p' )as date FROM comments WHERE tutorialid='1' ORDER BY commentid DESC LIMIT $offset, $rowsperpage";

 

Can I change the timezone for the date_format? i dont know how.. i need it in PST please help

[PFMaBiSmAd]

The mysql documentation contains a section on setting the time zone that is used by mysql - http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html

 

Depending on your access level to the server, you can set it globally on the server or you can set it per-connection (requires that you execute a query like SET time_zone = timezone

before you execute any queries that are time zone specific.)

[eugene2009]

I already read that article but it does not make sense to me because I do not have access to the server..

 

i tried this

$sql = "SELECT *, date_format(date, '%m/%d/%Y at %I:%i %p' )as date FROM comments SET time_zone = America/Los_Angeles WHERE tutorialid='1' ORDER BY commentid DESC LIMIT $offset, $rowsperpage";

 

 

this still doesnt work.. please help

[Mchl]

$sql1 = "SET time_zone = 'America/Los_Angeles'";
mysql_query($sql1);
$sql2 = "SELECT *, date_format(date, '%m/%d/%Y at %I:%i %p' )as date FROM comments  WHERE tutorialid='1' ORDER BY commentid DESC LIMIT $offset, $rowsperpage";
$result = mysql_query($sql2);

[eugene2009]

that does not work.. hmm i tried everything possible

 

somebody PLEASE HELP ME!

[Rustywolf]

date_default_timezone_set('America/Los_Angeles');
$date_format = date("m/d/Y") . " at " . date("I:i") . " " . date("p");
$sql2 = "SELECT *, $date_format as date FROM comments  WHERE tutorialid='1' ORDER BY commentid DESC LIMIT $offset, $rowsperpage";
$result = mysql_query($sql2);

 

See if that works

[Mchl]

date_default_timezone_set('America/Los_Angeles');
$date_format = date("m/d/Y") . " at " . date("I:i") . " " . date("p");
$sql2 = "SELECT *, $date_format as date FROM comments  WHERE tutorialid='1' ORDER BY commentid DESC LIMIT $offset, $rowsperpage";
$result = mysql_query($sql2);

 

See if that works

 

 

ROTFL

[eugene2009]

seriously.. come on. just help me

[Mchl]

If all else fails, you can try substracting time difference between PST and server's time zone