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

ImageCreate()
When I create an image and add text to it I want my text to be replaced with a PNG image, because th

mod_rewrite.c on windows ??
why it's not working on windows while it's working on other hosts???

this is the code i got

Default TimeZone
The server I'm working with is hosted in America so all times inserted into the database are coming

Comma seperated implode & modifying returned string.
I have a PHP post form that posts up to 4 variables. I need whatever variables are passed to be comb

convert static html data into dynamic
hi all

i need to convert a website which has static above 2000 articles into dynamic and add

Why does my php page download images over and over
Can anybody please explain to me why my php page keeps downloading the images and other items every

Displaying data from database into a 2 dimensional table
Good day!

I'm a beginner in PHP and I'm not expecting a full coding for this qestion. I'm jus

GIS appliction help
I found some tutorials in the internet to develop a map application I don't want to use google maps

Function to extract email attachments using PHP IMAP
function extract_attachments($connection, $message_number) {

$attachments = array();

Displaying image from database
Hi,

I've got a site where that's got a database behind it. Currently it has loads of items in

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