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

natcasesort works on one server but not on another
Hi

I have a problem that I was hoping that someone can help me with.

I'm trying to use

Am I setting up my sites oldschool?
Ok,

When I create a site I open a basic template that I have created that consists of a css f

Retail terminologys not been altered after activing Retail System
Hi, All

After I active Retail System via TCode SWF5, the terms does not been changed, th

distinct rows
Hi
version 10.2.0.3

I have a query output something like the following

ID

small inaccuracies
I have this code to convert fractional base 10 into base 2:

while($num > 0)

SWF image using php?
Hello once again.

My latest en devour requires me to produce an image of a static .swf that i

True way to see if action was successful?
If this is a good way to see if action was successful to continue:

Code: function changeGa

Secure FTP
Hi experts,
There is no SFTP action in MII workbench.
This means it needs developing custo

writing a screen scraper
Hello,

I'm writing a screen scraper application and want to be able to get absolute addresses

if statements problems
Hi. I'm trying to make a web form, but I kind of hit a dead end trying to figure out why it doesn't