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

TCP Sending Unsigned Char...
Hi...

I want to send over tcp/ip some data, i have the data in hexadecimal, and when i tr

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

How to generate a text file using php...?
Hi,
Can anyone give me code to generate a text file using php


Thanks in advance

Slow data retrieval which requires improvement..please help
I am working on a Help Desk Ticketing system and have a page called MY TICKETS which shows all ticke

Customizing message/behavior
Hi,I'm using the ASP.NET membership/authorization controls in my application. Some parts of my appli

How to display objects in a row
I have 7 codes that i want to display in a row one next to another.
The first is {$ads->ad

Problem with coding MySQL query
I'm having heaps of trouble getting one of my PHP/MySQL queries to work for some reason (and the fun

Basic Forum Tutorial
Hi, I'm new to PHP. I want to build a basic forum for my site using PHP and MySQL. I've searched t

Text to picture Generator
Hello, i have found this script and it works really good^^ But i have one problem, i would like to c

VAT
how should I deal with VAT?

if I have a product that costs £5.00 and VAT @ 17.5% (£0.87

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