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

Images in email problem
I found this script for sending emails, it works but if the email has <img src="image.jp

Php If in MySql query (hiding labels if a field is empty)
Okay, I've been trying to do this for a while, and I'm finally going to ask for help so I can get th

. and .. appearing instead of pictures
First of all, thanks very much for providing this forum. It is very much appreciated!

My son

ALV List display - header width adjust
Hi,

I am using REUSE_ALV_LIST_DISPLAY for my ALV display.The width of the ALV varies for

$_FILES array
Ok,

I just started experimenting with PHP today. My goal right now is to have people be able

Google Wave
So... has anyone used it yet? Is it any good?

http://wave.google.com/help/wave/about.html#vid

a very simple php header question (sorry!)
Firstly...I do apologise if this annoys anyone....a header error

I'm do not know php &

Extending Exception to contain method name
I was wondering, if there's a way to extend Exception in such a way, that it would contain name of a

timed header image rotation
I have a joomla site and I was trying to setup a rotating image based on timing NOT just refreshing

pop3 and fsockopen
So I am able to connect to the pop3 server, log in, and check how many messages there are. I am hav