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

Question about ShowWindow()
Hello....

I'm struggling with sumpin, and I hope y'all can help.

I've got a CFormView

Rounding a number queried from a database
I know that to display a rounded number you just do echo "round($number)";. But how would

PHP & Java
Hello,

can PHP code be used inside java code?

Code: [Select]<SCRIPT LANGUAGE=&q

dropdown box help - open php files to textarea
Hi, I am using tinymce to edit content located in several php files. The code I attached works but i

SQL query not working well
Hi,
I made a small table with 5 rows and want to make them an sql consult using rownum

temporary objects
Until now i thought every temporary object in C++ is created as constant. I'm wondering why my compi

PDO returns erroneous columns from within pdt
Hi All,

This is a truly weird behavior:
When using a simple pdo fetch, erroneous columns a

big pagination problem in php
<?php

$connect = mysql_connect("localhost", "root", "")

blank page.... nothing is happening.
I'm new to a lot of this but in the last 24hrs have learned a lot.
Installed latest version of my

array_count_values question?
ok i'm trying to create a top ten list from a database of listed favorite movies.

the followi