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

Need help with an email blocker for a guessbook
I am new with php and here is a simple guessbook page but I am being hit with spam from a group of t

printing links
Hi every1

i am connecting to a table in sql and the looping through with a while ($ var = my

Image loading
Hi Developers,

I'm trying to display an image from images/image.gif getting the url from mysq

trim function issues
Hi guys, total noob here...

So I've been tinkering around with a html and am using php to em

paginate search result
Hi, I have a paginations script to display data from my database but i would like to paginate someon

AUTONUMBER PROBLEM
Hello Everyone,

My name is Jones and i am new to this forum and to oracle. I am using ora

Help With Showing Users On the Index Page
Ive got this code which works just how i want it to.

Code: <?
$timenow=time();

Read from forum
Haven't written anything forever and I would like to get back.
What I'm trying to do is getting t

Seperate team from score
I am writing a site that does a NFL Pick 'em type application and I have a feed that gives me the sc

writing a screen scraper
Hello,

I'm writing a screen scraper application and want to be able to get absolute addresses

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