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

getAlexaRank($url) function not working
I have made a function to get alexa rank
the site is here:

All possible combinations of String in PL/SQL
Hi All,

Could you please explain the logic of getting all possible combinations of String

retrieving images from mysql database using php
So I've been trying to figure out how to store images in a mysql database, and as far as i can tell

using pspell, is it possible to get words that would be best in the current phrase?

For examp

I am stumped
OK. Here is what I am trying to do. I have the conditions set, and if the conditions are met, I want

foreach iterator
Hi Guys
Does the foreach loop have an inbuilt iterator ?

Tracking Unique Clicks
Hi guys and gals,

Basically I have a database which tracks clicks on my outbound links, I do

How to Detect it is public_html or httpdocs?
How to check whether it is cPanel or Plesk?

If it found public_html perform <?php incl

Why does my php page download images over and over
Can anybody please explain to me why my php page keeps downloading the images and other items every

Two warning messages
Quote<b>Warning</b>: mysql_real_escape_string() expects parameter 1 to

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