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

Call db table from any PHP file
Hi,

I want to be able to call a database table that will be setup in another file called init

serializing objects - loses methods - the point being?
Hi

I know that serializing an object will lose the methods. But whats the point in that? What

Php - mysql store data and use it later?
Hi, i' making a login page at the moment, however my username + password is stored many different pl

Find current logon time
Hi,
in my sql script i want to query and find out the logon time of the current session.
<

Help on code output
My CODE:

Code: [Select] echo "<phone>".$line["phone"].&qu

FILTER_CALLBACK -- Files?
Hi All,

I'm using the php filter functions to validate my form data. For custom filters, I'm

Help on query replacing the date
Hi Pals,

i want to replace the current date in a column to some value say C or D or any n

How to ... (FAQs)
... get e-mail notifications As several people asked how to get e-mail notifications when new posti

Custom list order
Hi there,

I have checked this tutorial and it's great till the point where I want to display

Intrastat Report Config in ECC 6.0 - goods Movement in EU countries
Colleagues, need ur help to understand the changes require in ECC 6 standard Report configuration se