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

Keeping data in form
How can I keep whatever I write in the form?

PHP mail() returns true but doesn't work
First off I apologize if this is a newbie question, and I generally don't like asking questions that

Email to a friend script problems
I have this send-to-a-friend script with 2 issues:


1) When you open the form popup on a p

Log $_POST
How would i log submits on a form, by everyone? I want to then echo the number of submissions.

whats wrong with my code please help!!!
this is the error


Warning: mysql_close(): supplied argument is not a valid MySQL-Link res

Join Query Help
Hi all,

I am having problems with the below code, which we shall call 'my first join query'!

extract content from a website
i have written a code that will grab the content from the index page..
i would like to know how c

contact form - output to page and email
I have the following in my controller:

$message['name'] = htmlentities(strip_tags(trim($_POST

Curl timeout breaks script
So im having difficulties with skipping timeout error in curl
my script calls different functions

Working with Global Variables
hi, I'm not really sure why the following code is returning a "Call to a member function getBan