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

Basic Question about Threading and PHP...
I have a page that I am working on and it is taking several hours to process. The basics of what th

Cant display mysql data
Hey all,

I am learning php and my first goal is to create a simple CMS. At the moment I am st

How to store checkbox array in a session, and then be able to add to it?
I'm trying to store an array of checkbox values into a session array, sort of like a shopping cart,

DataTable Help Required
Hi all I am creating an app that utilises and MS Access back end and queries it quite a bit at vario

Variable Clash
In the past I've had variables clash. For example:

Code: <?php
$c = 5;
$ca

background color imagefill
Hello

I would like to ask you why I see this square in red color just in my local xampp insta

help with variable
I've got a problem, i want to echo some images depending on the $id, however for me to get that id i

Insert data in Mysql and move to another page
I'm stuck with this simple problem. I need to insert data in Mysql and then hit submit and move to a

PHP Thumbnail Creation
Ok so i use this function to create thumbnails:

Code: [Select]function createthumb($name,$fil

Confusing Functions
So, I've been reading up on Functions and I like them! However, I need some help using variables in