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

Warning: mysql_num_rows() expects parameter 1
When i add quote at the end of this link
example:http://localhost/articlemania/category.php?cid=3

PHP Multiples of 2, Show posts...not working (wordpress)
I have been using this code to show div.example with 6 li columns inside it, each li is a post with

How to convert this array to string
I am having problems converting this array to a string
using print_r($val[1]); I get:
Code: [

Web Host List
Here is a list of web hosts that offer PHP and MySQL. It is no where near a full list, but it is mos

trouble printing an array....
I'm having some trouble printing out an array forwards. I'm figuring out the high and low of an arra

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

subtract 1 from value entered in text field
Hi

How do I subtract 1 from the vaue entered into a text field?

Thanks

how to configure ADS in ABAP instance
Hi All,

I am working on r/3 4.7 ABAP system.Can we configure ADS(adobe document services)

PHP Include not working
The website is http://www.grlistingservices.com

The code block is as follows:

<

Not "Just Another" MMORPG - text based.
Hello,

I've been learning MySQL and PHP for the last 2-3 years.
Though, I've had long paus