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

Mysql error message
help me find out what this error message means:

"Duplicate entry '0' for key 'PRIMARY'&q

SWF image using php?
Hello once again.

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

Random date selection
i want to select random date with time(hour+minutes+sec) where date is specified(10/22/2009) and tim

PayPal Redirect Issue
When I have my paypal button set so that is redirects to http://empiremarketing.ca/order.php,it work

strptime() equivalent for php4 ?!
Greetings!

this is my first post, thank you in advance for your replies.

Well, the ti

tag inside php...
hi


Code: <?php
echo "<td width="$columnWidth%" align=&

Check Date/Time in PHP
What I need the code to check is that $reQuest is 24 hours in the past then return a time based on h

Syntax Help
I'm trying to make a form that edits a php file which contains config settings. I'm using strings t

Coding question?
Hey guys, I have a quick question. If I want to make a way for people to pay for health in my game,

php problem?
I don't think I'm stupid, but maybe I am.

I am working on a sit for a friend I am try to put