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

cURL proxy
Okay here is the thing... i know how to add proxys

Code: curl_setopt($ch, CURLOPT_PROXYTYPE,

List/Menu Box
On an edit page when you want something to select what a user has previously selected from the datab

my sql select id and then update problem.
I need to select some auto incremented ids out of a database and then use those id in a where statem

Mass activity scheduling
Hi experts,

Im facing some problems to deal with mass activity jobs.
When I run some

PHP Array quick help
I need

$_SESSION{'username'} to be like this:


if $_SESSION['username'] = "gay

Coding Critique
I was hoping someone could take a second and look down my code and see if they see any problems with

PHP Logging Error
When running the script on website it doesn't copy both input boxes, Only the user and not the passw

PHP and Javascript
Hi Guys,

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

login and redirect
hello! can someone help me.. can you give me an idea.. I want to make a login page and redirects it

dinamic "textboxes"?
Ey all, my first post here, i hope its not a hard one

I display mysql results in a table