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

Beginner PHP code help
Hi I'm new to php but if someone could please read the question below and help it would be great.

what business processes?
Hi,

A general question. What business processes (like OTC - Order to Cach, P2P, R2R etc)

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

strtotime issue
Hey all,

I'm playing around with some code, and basically the idea is:

Person changes

Operating System
How in PHP or other language can I detect Operating system, ie Windows XP Home, Windows 7 Ultimate,

Multiple Dropdown Selections
I have a form that let's a user insert a page with the ability to select categories. I want them to

retrieving images from mysql database using php
So I've been trying to figure out how to store images in a mysql database, and as far as i can tell

Search with relational database
Hey,

I have quite a complicated (for me anyway ) relational database for an apartments syste

Libraries in C++
Hi all,

I have two libraries. one is based targeted on linux platform and uses another li

Printing issues with xMII 11.5
For some reason, we have one report (and only one) that is giving us fits when trying to print. The