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

GET * FROM _____ Except?
I have a site that is for stock photography.

This section of the code calls images to display

Rss feed question
Hi

My blog and my website are different. Am i able to take my rss feed
from my blog and p

PHP hyperlinks generator
Hi

I need some help to get this done using php:


1 - I have few hyperlinks say 500

how to remove in php string display
My code is $message="We're looking at developing our website."; $body= "My mess

DateTimeZone::listIdentifiers headache
http://php.net/manual/en/datetimezone.listidentifiers.php


So the documentation states tha

PHP Captcha Error help - replace the "die" command
Hi All,

I am after a bit of help with a Captcha spam protection box.

The site gave me

MySQL Primary key gap
Alright, so I have a table with 26 entries in it (id, filename, caption) for my image randomiser (ht

Significance of BPM
Hi Experts,
I am a novice in BPM , I just want to know how BPM as permenant department is

Date Question
I'm using the TIMESTAMP() function within mysql to set the date/time for certain events. However, ho

mysql select with $_get ?
Hi, i have this code:
Code: // If char id is 0 and character dont exist do:
if ($_GET["id