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

Remove values in array2 from array1
I have two arrays.

Array 1 is where the array key holds various different numbers. For exampl

Display Database
I need to create a shopping cart. I found this code online: http://conceptlogic.com/jcart/
Unfort

Syntax error
hi im having a little trobble with this script
-------------------------------------------------

Comparing two dates
Hi Guys
I have two dates I want to compare. Below is my current implementation. The problem with

Socket programming
Hello all,

I have a PHP socket script. GPS trackers connect to this socket. IMEI verification

my code does not work.
I have a code problem.

Quote"<a href=index.php?gogo=ureticidetay&'?l={$le

Need help with basic sql
Hi,

I am using oracle 10g, and having some small doubts related to sql , here goes the si

Multiple Dropdown Selections
I have a form that let's a user insert a page with the ability to select categories. I want them to

filesize() returns 0
I have a socket program that runs in an infinite loop, listening for connections, in this socket I h

need a script for 3 pages
I have a customer who wants me to set up a site with a number of pages with the following requiremen

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