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

Your Answer:

Login to answer

Other forums

Sending an SMS Message with ASP.NET
Often times it may be a requirement for your web application to send an SMS message. Such examples w

Login logout link help
Hi all,

Im new to php and Im having trouble creating a login/logout link for my page that dis

adding up might be solved tell us cheers.
i think i finally solved this anybody.

last time i was getting the wrong results.

Code

mail() says sent but no email received
My code is quite simple:

Code: <?php
$to = "Ty44ler@yahoo.com";
$subje

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
Upload Code Help 
Hi everyone I need some help with a bit of code ive been working with for a while. I am completely s
Procedural to OOP 
John Kleijn said that to avoid writing "crappy code", we should learn OOP and common OO pr
Checking BOM Authorization Group 
Hai Friends,



I have developed a mulitilevel BOM display report. End users have been assig
close site for maintenance 
i get a tutorial, saying the following code can put our site offline, and only the developer can vie
Weird MySQL error, why am I recieving this? 
PHP Code:


<?php require "global_settings.php"; ?>
<titl