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

database design
Hi,

I got a page which allow candidate to type in their previous working experience,
I let

Calling strings from other php class
I have test1.php{
$string1;
$string2;
....
... //10 strings in this class <

Locking mysql tables with php
Hi

BACKGROUND:
I have multiple instances of the same php script running in a WAMP environ

Bar charts using Graphical Framework.
I am using Graphical Frameworks(GFW) to create a chart Graphic . There is no problem with the data d

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

CRM?
I think that's what they're called. Customer Management System? Anyway. Is there any good free ones

mail with attachment problems
Hi. I have the following code:
Code: else if(file_exists("site".$timp.".zip")

Shuffle Array
Hi,

I am writing a script for a game that needs players to randomly be assigned a target (ano

ASP.NET 2.0 - Enter Key - Default Submit Button
Hi,One of the most annoying things in developing web pages is handling the "Enter key" for form subm

help understanding hidden input w/ php
hello i'm doing a tutorial where there are multiple forms for an edit page for a user to update thei