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?

No comments posted yet

Your Answer:

Login to answer
51 Like 32 Dislike
Previous forums Next forums
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

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