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

why isn't this PHP code working ???
it's suppose to find a name on the database.

<?php

$s = $_POST["lname&

Renaming a file that a user uploads to site?
My site allows for registered users to upload images to the site under their own gallery. Currently

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

dropdown menu
Hello everbody,

I am php newbie.
I need to develop a program that once click the drop do

foreach iterator
Hi Guys
Does the foreach loop have an inbuilt iterator ?

how do i make a string??
hey guys,
can someone please tell me how to put data from the glob function into a string

Disable Scrollbar in TableControl
Hello everbody,

please can anybody help me - outherwise i'm going to become desperate :P<

calculator
I can't figure out why this code doesn't work. No error messages. Page loads.

Code: <

form problem
below in the form action, i've put "test.php?w=$sw&h=$sh" but when i input the for

admin with my register system?
Hey i wana make it so i can make a admin level on my register system , I'm kinda new to php to im no

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