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

need help to creat database
Hello Team, please guys i am stuck from three days with paypal issue for IPN but no luck yet now i w

EXplanation help
Hey all,

I am still fairly new to PHP programming and I am trying to put together a page wher

weird problem
last time, i did post a topic concerning why my page sometime will load as blank page when using IE.

distinct rows
Hi
version 10.2.0.3

I have a query output something like the following

ID

Simpler method of getting variables from mysql
Hi Guys,

I'm trying to streamline my CMS's code and as I was writing a new page it occured to

validating url
im trying to validate url's sent to me by a form
the url's im collecting are for placing banners

Mass activity scheduling
Hi experts,

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

Connect to database that isn't localhost
I am currently doing a small script for a company that doesn't have mySql support on there hosting.

PHP Surveys
I really would like some advice.

If you have a client come to you asking for a survey to be d

noob cURL help
I have a pretty basic form that I need to cURL post to a file in my includes folder (includes/login.