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

Need Successful Return
Hello I am currently working a form here, and I have everything figured out except when I click the

Help with Contact Form
I have this Form on an html page and the associated code on page.php (below).
I keep getting the

upload form file types....
Hey all, I am learning PHP and I am writing a script from the W3C Schools tutorials for uploading fi

Form errors in an array
I'm processing a form and putting the errors in an array. empty($errors) doesn't seem to do the tric

fwrite error
Hi All,
Does anyone know what is causing the error in this code?

Code: <?
$error

Uploading/Downloading files stored in MySQL database
Hey all,

This problem just came up in my website and I'm having a hard time figuring out what

please help
HTML Code:

Code: <span id="ctl00"><span>

How to display random record from table?
I have the following code:

Code: <?php
$display_block .= "<input type=

Image upload - determine folder
I have an upload script that may be accessed from different directories. Problem is, the script is m

PHP SUBMIT
Code: <input name="doLogin" type="image" src="images/loginsubmit.jpg

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