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?

Did you know?Explore Trending and Topic pages for more stories like this.
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?
No comments posted yet

Your Answer:

Login to answer
51 Like 32 Dislike
Previous forums Next forums
Other forums

Why does my crawler script suddenly end with no error?
Hi.

I have written a web crawler script. It will visit a large number of URL's with cURL.

why preg_match_all does not return the number of matches
My regex looks like

X[^x{4e00}-x{9fa5}]*Y

(where X and Y are two Chinese characters)

Disable html within defined tags
I have a mysql database that allows users to enter content with html, but I also want to have a tag

Need help urgant
why down my code ony return one item instead of all the items selected.

$arr = array($date,$

image upload script not working with png
The basic process of this php code is to take the submitted file, convert it to a small JPG thumbnai

Table trouble
i have been reading the forum for a few weeks and decided to join. i like the format and the advice

Socket problem
Hello,

Earlier I posted about my problem with my socket script. It took up to 100% CPU usage.

Filtering Tables
Hello Thanks for any help any one can give Im very new to PHP..

I need to pull data for clien

php slowing my site?
Hi all,

I think that one of the reasons that my site doesn't work fast is that the code is ve

Need help making a script that moves data into acrhive table
Hi,

I'm kinda new to php/mysql

And i wrote a simple script to store sales lead for a b

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash