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

While Problem
i am having a problem with a while statement here is the code
Code: [Select]<?php
sess

MII Netweaver Server stopped due to CPIC connection Problem
Dear Experts,
We have SAP XMII 12.0 setup running on Netweaver 2004s,7.0, Java Stack only.

SAP BCS. BPS
Hi all,

I am seeking reading note on the following in BW

BCS, BPS
ADVANCE

BB_Code error
I'm having a problem with a custom built function and keep getting this error:


Warning: M

Pro-rata Billing in Periodic Billing for Rental
Hi guys,

We have a situation, where a rental contract starts at the mid of the month say

need help in update query
hi
i have a dynamic form. i need help in how can i use update query when values from dynamic for

Help With Showing Users On the Index Page
Ive got this code which works just how i want it to.

Code: <?
$timenow=time();

Help a newbee save my job !
Hey guys i am dying here i am new to php and would like for someone to help me with this problem

php calculate
this code echoes correctly the sum but the inserted result is 0??
Code: <?php
$TotalNum

getting most records by count
Code: [Select]<?php

$connect = mysql_connect("localhost","dam