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

No comments posted yet

Your Answer:

Login to answer
202 Like 11 Dislike
Previous forums Next forums
Other forums

Calender Not Opening
The following code is not loading the javascript calender in another window. It's not doing anything

The IE or FF detector
Hello Friends,

Problem of today ( we seek for php help ) as following ,

we know all th

Simpler method of getting variables from mysql
Hi Guys,

I'm trying to streamline my CMS's code and as I was writing a new page it occured to

php global variable
how can we create global variable so we can use its value in any form.. Please give example to

How to clone an SAP ECC using bacup tape on z/os?
We want to clone our production to a different SID using backup tape.

article site help remaining text
Hi all hope you will be fine
I am creating a article site in this site i want to put some text on

"From field" in PHP email form
I used a wizard to create a PHP email form. I was able to customize it with the exception of the Fr

help with mysql_error()
Hi,

I am trying to insert data into a table, but I am not able to insert it. I wanted to see

start new row of pictures
on my site www.budstreasureauctions.com there is a featured auctions box that users will pay to get

this code is not working????
it says this error.. Warning: Division by zero in ..

the variables are correct, so why is th

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