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

Creating a unique 'control panel' for each user
Hi there,

I'm thinking of designing a site that will allow users to sign up and have their ow

Custom CMS
This is a big custom CMS script I'd like to develop and would like some help atleast figuring out wh

New to Arrays
Hi I am new to PHP (a week and a half now) and I am just beginning to read about arrays. I understan

ldap connection
We are using ldap to get user information from the domain controller. It was working before. Recentl

Add code to enable passing of checkbox variable on login
Ok, I have a login page, but want to add a checkbox that when checked and successful login is made i

Check if another session of the page is running?
I want to keep people from opening multiple tabs, or sessions of my Facebook app. Is it possible to

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

Code: curl_setopt($ch, CURLOPT_PROXYTYPE,

Pagination
Hi All,

I think I'm finally getting somewhere with pagination!

I can now submit a quer

Problem with PHP code- simple contact form
I'm relativily new to PHP; I know HTML and CSS stuff but I have a problem- I have a contact form wit

Removing Title From database problem
Hi again ! i am having an issue with updating database. When i update any price of a title it remove