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

Strange PHP/mySQL error ... am I just tired?
Code: <?

## CONNECT TO DB FUNCTION!
function ConnectTo($db2con)
{
$hostNam

How to Handle more than one submit button in single form?
Hi
I have one PHP file which contains one Form. In this form there are two Submit type Buttons

writing a screen scraper
Hello,

I'm writing a screen scraper application and want to be able to get absolute addresses

article site help remaining text
Hi all hope you will be fine
I am creating a article site in this site i want to put some text on

how to remove in php string display
My code is $message="We're looking at developing our website."; $body= "My mess

ob_ dynamic content
i was wondering about the potential to use ob to create a <div then remove it when the page

Quick fix: Conditional statement with an array
Hi, I'm getting the temperature value off of the Environment Canada website along with the icon file

list files from folder, only one for each date
I have many files in a folder and wish to only list one of each date

these are the file names

Error in write byte array into document in SM58
Hi Gurus,

Getting the following error status in Transactional RFC (SM58) ..... *Error i

Setting a default timezone?
I have read about how to change the timezone in PHPMYADMIN, but it changes back, it doesn't STAY the