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

Table Control
Hi Guru's,

I've created a Module pool program, which contains the Table Control.

very easy question about SQL info
Hello,
I think that I have a very easy question.
I know how to create a form using php SQL and

Forms Authentication and Refresh at Login page
Hello, When I try to press the Login button in my webapplication at my login.aspx page nothing h

Get last modified date of web page
Hai All,

In php how can i get last modified date of a give web page . I have tried to g

does anyone know a php script to send mail using gmails/googles free smtp server
cause i heard u can do that but i dont know how

PHP Form to Variable.
Hi! I have written a HTML-form code in DreamWeaver CS3 (in a PHP doc) and I really need it to work s

PHP Function Page Advice
Hi All, I am quite new to PHP and Javascript but have written an Online Shop (Mainly for Fun and edu

utf8_general_ci error ??
I have all kinds of data to be inserted in database table

//I am getting this error

Yo

str_replace help
Hey there,

I'm a PHP newb, I'm having troubles with the str_replace function. I want to clean

first few characters only
hi, does anyone know how to use PHP to take the first few words of a text and limit them? i have see