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

Where am I going wrong
Been trying to work this out for hours

I have two tables called 'Genres' and 'Films'. Genre

Problem with passing variables
I'm not really a php programmer so I'm really struggling with this issue.

I have a banner s

import table with dependency
Hi

What is the best way to import table back which has dependency?

SQL> cre

SOAP Issue
Hi,

I am facing some understanding problem with SOAP basic.kindly recommend some SOAP expert.

Passing Arguments to execlp()
I'm writing a program that mimics a unix shell. It's supposed to take commands with arguments and ex

Validation
Hello

I know this is a really vag question.

I need to have a input field on a form th

CURL XML Request [From C to PHP]
Hi,

I need some help converting this into something that will work with PHP.

Code: #

Display last record first.
I need some help how put the last record first and first record last.

Thanks

Code: &am

array_combine() trouble w/csv file
I have a problem with a piece of code I wrote to import some records from a csv file into mysql. I h

login to other site by sending post variables
hey,

here is my problem: my school gave me a mail account for school-stuff use. they mail us