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

Something like an INI editor or a DelimitedText-Editor
Hi all,

Am very, very, very new to PHP and not sure if I should be posting this to a Javascri

Storing Values taken from a DB...
Using this code it will generate a short list from my database

<?php
mysql_connect

Pulling out some result data from MYSQL
Hey Guys,

I've built a PHP page that has a for just imagine something like registration form

Need help in Generating Combinations
Need help generating all possible combination of names in an array

Lets say i have the follow

Multithreading design
Hi

I have come up with a Singleton class that manages a pool of database connections. Basical

Calander layout
Hi i know this sounds like a simple question but i cant find the answer to it anywhere i have added

Schedule editor
Hi,

I have a question related to Schedule editor.
If we schedule a BLS for every 30

Month String to Numeric?
Hi guys,

Given a month as a string, is there a simple way to find the numeric representation

Does deleting the spmlog directory critical?
Hi Everyone,

Please, hope you could help me. We're having problems with the SAP backup. I

Table colours fail when extra row added
Hey Gurus,

I got a weird problem with formating the colour of a table made in php. Everything

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