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";
Did you know?Explore Trending and Topic pages for more stories like this.
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

Keeping data in form
How can I keep whatever I write in the form?

New Search Engine
Hey everyone,

I have a ZIP Code Radius search engine already functional. it displays all of t

Product categories for registration
Dear all,

We are going live with the Supplier registered next week. At standard, the 'sel

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

Get to know your fellow coder
I think it's time we got personal around here. There's a lot of code swapping and a few members kno

Include a php
Hello,

I'm trying to include a function that shows the recent searches.
Example I have <

Am I setting up my sites oldschool?
Ok,

When I create a site I open a basic template that I have created that consists of a css f

Change Web page language
i doing this thing first time but i dont find any suitable solution for it. On the demand of user. I

Create a form of 2 numbers input and find the greatest.
Hi, everybody.

I have a homework in my training of php, which ask you to make a form that ask

Help: problem with Headers to download PDF file
Hi,

I'm trying to implement a script where when a user clicks a link he gets a PDF file to op

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