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

login and redirect
hello! can someone help me.. can you give me an idea.. I want to make a login page and redirects it

PHP Login
Hey!
I got this shopcart code online, am trying to modify it but am getting an error when i try a

Multiple arrays inside data
Hi,

Simple question. I have a column called "array" in my database, and inserted in

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

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

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

i need help with php header and footer
I have designed a header and footer for my site and they seem to be ok when they are running individ

Any help with my email script?
I have an email script, I have not tested it, although someone tested it for me and said it worked f

Procedural to OOP
John Kleijn said that to avoid writing "crappy code", we should learn OOP and common OO pr

Onclick problem in Firefox
Hi,
I am using a . It doesn't seem to

Remove Rows From Database ad
Hi All,

I have this:

Code: [Select]<?php
session_start();
include('../com