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

login and redirect
hello! can someone help me.. can you give me an idea.. I want to make a login page and redirects it

try catch error
I have been trying try catch but, I can't get it to work. The code opens a non existing file called

Is there a quick way to do this?
Hi all,

I need to create a mysql table from php that goes a little something like this

Change image filetype on upload?
Hi,
I've got a form which uploads an image to the server.
Is it possible to change the image t

insert quotes
Hi,

I have an output like this:
Code: john,18,Cancer
How can I change this to
Code:

Wierd echo error?
Hi, i got the most wierd php error ever and i don't know why..
Code: echo "<t

Multiple forms on the same page (safari)
Hello everyone,

I have 3 forms on the same page, that opens in a new window and submits to a

UPLOAD IMAGES NOT WORKING!
Hi there i have a upload script in which it uploads the picture to a folder than creates two thumbna

My query is being run with no results.
I have this.

Code: function DropUser($duser_id, $user_email, $user_username) {

Notice Undefined index: reset/ Attempting to redirect, works, but get a notice
Full Header.php is:
Code: [Select]<?php
$reset= false;
$reset= strip_tags($_GET[&quo