MySql timezone

Posted on 16th Feb 2014 07:03 pm by admin

Code: $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

Your Answer:

Login to answer

Other forums

Entering Data Problem
Code: $result = mysql_query("SELECT * FROM flights");
while ($row = mysql_fetch_array($

Multi Dimensional Array Append
Hi Guys

I have a function that returns a multidimentional array eg

$result = functio

Xacute search within SQL results
I have a query that is pulling data, and I want to return a specific value from the results of that

Oracle Connectivity
Hi Every One,

Can we access SAP from oracle database.If it possible then please spec

small inaccuracies
I have this code to convert fractional base 10 into base 2:

while($num > 0)

tag inside php...
hi


Code: <?php
echo "<td width="$columnWidth%" align=&

Shopping Cart
Can anyone direct me to a Simple, Basic structure of a shopping cart.
New to classes. I want to s

Restricted access to sub-folder in iis6 doesn't work?
Basically I'm trying to add restriction to sub-folder (which contains pdf) in web.config for iis6 as

Deleting a record php
Attempting to setup delete a record page. The below code I put together doesn't seem to work.

value not going in data base
hello friends....
i am having a working javascript....when i am selecting any