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

Simple Question
I know this is a simple question, that if I knew what it was technically called i could probably loo

Update Database
Hi All,


I have a problem with this:

Code: [Select]<?php
session_start();

How to replace search button with link?
hi to everbody.
i have a search submit form and button like this :

<form id="f

foreach iterator
Hi Guys
Does the foreach loop have an inbuilt iterator ?

Fatal error: Call to a member function fetchrow() on a non-object in C:xamppht
okay i have this query and everytime i add `item_id`=? to it... it gives me the error in the title..

update post issues
I am trying to create an update to a post function, while the update does occur, the page routing an

Greek characters in php
Hi,

I'm making a script and I m using for first time greek characters.
I started to write

To add a field on the screen XK02.
Hi All,

How to add an additional field in the vendor change control screen XK02.
The

count only commas outside parenteses
I have a sql table containing
id - query - query name
the first page contains a drop down men

Simple AND question
Hello,

I've got following code:

Code: if(strpos($row[13],"http://")

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