Date Question

Posted on 16th Feb 2014 07:03 pm by admin

I'm using the TIMESTAMP() function within mysql to set the date/time for certain events. However, how would I go about formatting the output? For example it would display "2009-11-30 02:48:40".. how can I change that formatting around?

Also, I wanted to do a sort to display items within my table monthly.. is there anything I can use to only pull/sort data by the month?

Your Answer:

Login to answer

Other forums

Problem in back link
I have page where i have given javascript back link but when i click on it browser give a message

Nested (echoed) php running wrong script
Got a problem with a php website I'm creating.

In a nutshell, the first page is entirely html

Require select-option functionality in Module Pool Programming
Hi Gurus,

I am doing a development by Module Pool on Warehouse Management. For that devel

PHP and Javascript
Hi Guys,

Im trying to load the contents of an html file into a text area for editing, this is

j1inmis Ouput layout changes
Hi,

Can anybody tell how can j1inmis output layout can be changed so that vendor names ge

PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page wi

Links not updating
I'm trying to fuel a simple navigation system for a news section. It works fine when it comes to ret

paginate search result
Hi, I have a paginations script to display data from my database but i would like to paginate someon

Results from Db outputted twice
Hey guys.. for come reason my data is outputted twise shown in the image below and i cant figure out

Changing files over
Just thought I'd start with the new forums looking really nice .

Ok basically I've made this