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

Connection Timeout
I'm using xmii 12.0

I'm calling a transaction as a web service from a windows application

Passing PHP variables from one page to another
Hello-

I'm having trouble figuring out how to transport a variable from one php file to anoth

Need help to identify this error please
:confused:Can anyone help me tell what this error message means? Maybe tell me where to look to fix

curl javascript problem
Hi Experts.
I'm new curl and wanna to get some info from this http://www.amadeus.net/

when

how can i display php source code snippets ?
I am outputting some pho code .. and I want to display the source code so people can copy and paste

Tracking Unique Clicks
Hi guys and gals,

Basically I have a database which tracks clicks on my outbound links, I do

an interesting question
Greetings folks, got to ask an interesting question...

let say
i have created a function s

Why is the logic of this simple code not working?
Hey, I'm trying to determine if a table already exists in mysql, but doing a query first with mysql_

Help uploading .JPG
I have a problem with upload images when the ending is .JPG capitalized.. I really don't know what c

foreach loop, assistance request
I would like some guidance on the usage of foreach as I try to parse through a large database and wh