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

Extending Exception to contain method name
I was wondering, if there's a way to extend Exception in such a way, that it would contain name of a

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

Website Direction...
I recently used this code to try and make it so the page loads as http://www.domain.com/ when you ty

PHP url branch??
Functionally, using PHP, I'm doing a test of login input submitted by a user via an html form in a f

Dynamic memory problem
Hey,

At the beginning of my code, I have this line:

Shape* gShape = 0;

Weird MySQL error, why am I recieving this?
PHP Code:


<?php require "global_settings.php"; ?>
<titl

Progress bar tracking file downloads
Hey guys, was wondering if there was a way to track how far a file has been downloaded. I know there

Using two $_POST Function / Switch () statements, second does not work.
Hi all. I’m new to php and am having a problem getting $_POST Function / switch () to work. I

MVC - Code review
I'm in the process of trying to wrap my head around MVC, and as part of that, I'm attempting to impl

listcube issue
Hi
I have a virtual cube ZREMOTE. I use Tcode "listcube" to retrieve contents. I use of the

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