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

how to insert value
I am having file bookissueadd.php..... in which i am having tag

<td height="21&q

defining website tags
Hi,

What would be the best way to define tags for my site, such as website title, url etc.

Load file in PHP
I have 2 files. The first is a PHP generated XML file that's dependent by 2 inputs. The second is a

upload image name with extension using php
hi frds..

<input id="file1" type="file" name="file[]" &a

need help to creat database
Hello Team, please guys i am stuck from three days with paypal issue for IPN but no luck yet now i w

storing video files into mysql in php
hi

i have my video files in my folder ,
i have to store the path of the videos into db an

Progress bar tracking file downloads
Hey guys, was wondering if there was a way to track how far a file has been downloaded. I know there

Not adding to db
Hi, I can't figure out why it won't add the record to the database. It's just a simple form to get

form problem
below in the form action, i've put "test.php?w=$sw&h=$sh" but when i input the for

single page with referrer to show correct page
I have a simple website with a couple of different pages. I would like to be able to in a div tag w