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

No comments posted yet

Your Answer:

Login to answer
202 Like 11 Dislike
Previous forums Next forums
Other forums

Getting a variable to work in function params
I have this fuction which is inside a class:

Code: public static function generateEmbedCode($

unexpected T_SL without a shift left token
Nothing too see here, I'm an idiot and resolved the problem.

present value of sequence?
Hi

Please help me to find out the present value of sequence?

Thanks

DB2 for z/OS, LUW, iSeries
Hello, In this forum a lot of threads related to other members of the DB2 family than DB2 for z/OS

why aint this working?
i have this code:

Code: $num = 250;
$count = ($num - $rcount);

echo $rc

ldap connection
We are using ldap to get user information from the domain controller. It was working before. Recentl

! = ''
In the following 'IF' statement if v_ompcat = PU for example then Oracle equates that 'IF' statement

how to get different value in second view of webdynpro?
hello guys,

In ABAP webdynpro I am trying to create one application having two views.

Post PHP form to non-existing page
The company that I work for host their PHP code on IIS on a Windows server, no Apache, so no mod_rew

how to easy edit text, with box? Help.
Hi.
I have a little problem. I'm doing a webpage for my aunt and I would like to make it as easy

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