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

please help me in this update statment
hi every one

if I have table and this data in it

id name
10

Saving PHP output as a file
I wondered if anyone knows how to save the rendered output of a PHP script as a file?

I have

True way to see if action was successful?
If this is a good way to see if action was successful to continue:

Code: function changeGa

Alterar a hora do servidor
Se alguém souber, ajude-me a adicionar 6 horas, obrigado
<tr>
&

mysql timestamp manipulation
How could I use a timestamp (e.g 2009-10-30 13:20:35 ), and with php find out if it is:

from

Most basic form question ever?
Hello,

I want to use this snippet to make sure the fields in a form are ok before processing

confused between ' ' and " "
there is a php i set:
$begin_date_query = mysql_query( "SELECT SUBDATE(due_date, INTERVAL $d

i need help with php header and footer
I have designed a header and footer for my site and they seem to be ok when they are running individ

Displaying values from a SQL count...
Hi,
Easy enough question i just forget the exact method ..
I have ...

Code: //count win

Upload simple problem
Really confused!! I run once and it worked, but when i tried today...it didn't work

Which par