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

202 Like 11 Dislike
Previous php-forum Next php-forum
Other php-forum

Upload, SSL and more php help
I recently just installed a ssl cert and do i use https for the whole site or just for the checkout.

Email "$"
Hello!!

Any PHP guy with a bit of a knowledge in Flash ?

When I send a JPEG from flash

Problem!
I have another problem, when i run this code i get this error "Parse error: syntax error, unexp

PHP and Javascript
Hi Guys,

Im trying to load the contents of an html file into a text area for editing, this is

insert mysql embeded videos as blobs?
Using TinyMCE my client will be able to embed images and flash videos into large columns of text whi

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

PHP Game
hy i was wondering what's the best method in order to make some automatic updates in a php game
<

switch not getting value
what am i doing wrong?
i want to populate the country list according to the category
i want to

foreach loop, assistance request
I would like some guidance on the usage of foreach as I try to parse through a large database and wh

Pls help with PHP
Pls can anyone direct me on how to create a user account for a customer. For example i want know if

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash