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

Slashes
Have a small problem and I'm not able to understand why I'm getting the results I'm getting... and i

Backflush
I am looking for a report in SAP that would give me a list of all parts that are populated with a ba

Count of reciepients in php mailer
How can i sent a mail to large no of reciepients say 10,00,00 Using PHP MAILER

problem when runing a funciton
I am trying to connect to database using a funciton in a functions.php

<?php
funct

FILTER_CALLBACK -- Files?
Hi All,

I'm using the php filter functions to validate my form data. For custom filters, I'm

Coding question?
Hey guys, I have a quick question. If I want to make a way for people to pay for health in my game,

Login page problems
I developed a website a few months ago and I am now having an issue with logging into it. The place

Pop-up Banner
Hello Friends,I need to use banner in our client site.Example: www.example.com if i enter this site

Calling a Procedure with IN & OUT Parameters
Hello,

I usually call my procedures using the following way

declare variable e

Retreiving objects from Sessions
Hi all,

I am getting really frustrated with storing and retreiving objects from a session. Bu