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

Little problem with form insertion in MySQL, Please help!!!
Hi!,

I'm a little bit new with php and I have a little issue here. I created a webform to ins

Function
How can I make this function that once you click the link in the code it takes you to a new page wit

passing data from one page to another
hey guys
i have the follwoing code to get information from one page and place on another:

php code generators
All

Whilst enjoying learning a new language i have come accross a number of free code generat

Using CSS to format MySQL query
Hi,

If i want to have a news page on my site, which displays all records of a table in descen

How to display objects in a row
I have 7 codes that i want to display in a row one next to another.
The first is {$ads->ad

How to validate from 2 possible answers
Hi

I hope somebody can help me with what will probably be really simple, I'm pulling my hair

WHYISNT THIS MYSQL STATEMNT NOT WORKING? (php)
caps because its absolutely rediculous.
i dontunderstand why its not working. there is a column c

Load file in PHP
I have 2 files. The first is a PHP generated XML file that's dependent by 2 inputs. The second is a

this code is not working????
it says this error.. Warning: Division by zero in ..

the variables are correct, so why is th