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

Hashing?
Hi, I was hoping to take a string value then convert it - consistently - across each of our pages in

Creating a custom API
I'm creating a site, and I need to create a basic API. Unfortunately I have no idea where to start.

browse folder only
hi,
is there a way i can browse or get the directory or folder only and not the file?
i just w

Code error with Index.php
Error: Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/runevid/public_

! = ''
In the following 'IF' statement if v_ompcat = PU for example then Oracle equates that 'IF' statement

Problem with array max size.
Hi to everyone,
I've got a homework about filling a bidimensional array un spiral shape, I alre

Trouble with a select list
Hello All!
I was wondering if any of you guys could help me with a small problem I'm having!

Take info from one coloum and move to another
Hi all,

I have this:
Code: [Select]$array = "SELECT stock_id FROM stocks WHERE stock_

i have no idea why this isn't working
Code: <?php
session_start();
include("connect.php");

error_reporting(E

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