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

Printing a webpage
I use this to print the webpage: o

strtotime issue
Hey all,

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

Person changes

defining website tags
Hi,

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

values not being entered into table
hi. I;ve created a form, so that when a user enters data into it, it gets added to a table in a data

InternetOpenUrl() Invalid cert
Hi all,

Does anyone know how to prevent calls to InternetOpenUrl() from failing with erro

Session problem?!?
Hello All! I am very new to the php world but I am working on fixing things that a previous programm

Problem with coding MySQL query
I'm having heaps of trouble getting one of my PHP/MySQL queries to work for some reason (and the fun

C - Reading a file into a byte array
Hi,

I'm trying to read a file into a byte array in C. I have to use C as this is for a loadru

Parse error: parse error in C:wampwwwlogspagesmembers.php on line 16
I dont see the problem with this, I always get Parse error: parse error in C:wampwwwlogspagesme

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