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

str_replace help
Hey there,

I'm a PHP newb, I'm having troubles with the str_replace function. I want to clean

Need help with an email blocker for a guessbook
I am new with php and here is a simple guessbook page but I am being hit with spam from a group of t

TemplatePower & AJAX
Hi all,



I'm currently implementing some AJAX features in my PHP-framework (which is b

C++ API to Oracle dB
I need to perform a select command to the Oracle dB to obtain information from a table.
What libr

moving mouse to display image coordinates
I have an existing MFC application that shows an image in the main window.
I'd like to be able to

Access website from only 1 computer...?
One of my customers wants his website to only be accessed by people in which they bought the website

SAP FICO learning materials
Hi all,
I am new to this world of SAP FICO. I have taken training on SAP FICO, but was wonderin

image upload, resize THEN submit form
Ok so I have a form that requires the user to upload an image, and then do something with that image

Alternate messaging
I have 4 strings in MySQL db1

$string1 : Hello
$string2 : Hi
$string3 : Great
$strin

Passing Variables
What I'm wanting to do is when the user clicks on Arenas it will know the name of the country it's w