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

Target costs on Process orders not calculating
Hi All,

We have released standard costs for all the materials. We have also done Goods r

Php Mysql Page Loading Notice
Hi all,

I was wondering if there is a way (Sure there is) of showing a message or an image wh

xml element exists
Code: [Select]<?xml version="1.0"?>
<Addresses>
<

Performance impact of cookies
Hi, I was just wondering what impact there would be in terms of performance if you where to set then

help with insert
Hi there,

I am trying to insert some data into a database, but for some reason, it is not ins

Displaying data from MySql a different way
Hi all,
I'm pretty new to php and MySql and have hit a problem.

I am able to display data

Displaying an image using echo command
I had done a query on my database, one of the fields being an image reference to a directory where a

passing an array of objects after submit
How do I do this? This is what I have tried and it is not working.

<form method="

help removing unwanted graphic
How do I remove the small elongated rectangular shape between the "Latest post" and "

RSS poster script?
I have found a script that posts RSS's for me on a site that I'm building. However I would like to a