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

Output Full URL of Current Page
Let's say I am currently viewing a dynamic page:

http://www.mydomain.com/directory/index.php

printing links
Hi every1

i am connecting to a table in sql and the looping through with a while ($ var = my

Login Issue's
Code: <?php
$file = fopen('user.txt', 'r');

/* Set login to false initially */

records between 2 dates
Hello all,

I have a date tracked table which contains effective_start_date and effective

Help Ordering Arrays
Hi, I have 3 arrays as shown below.

Code: $users = $this->get_latest_users();
$flir

Pagination
Okay here is the page in question: http://blenderteachings.000a.biz/tutorials.hamishhill.php

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

making web pages for accounts
Hello, I would like to make pages for accounts on my website im making (its not a real website..im j

array_map() probably obvious mistake
The code below is part of a class to escape strings, but should also accept an array, using array_ma

Last character removed
I have created a string from an array. I have inserted commas from my form values. I am trying to re

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