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

Creation of Raw Exposure manually
SAP Gurus

I am creating Raw Exposure ( Hedge management ) thru T Code TEM10 with followin

How can I get my program to read a larger array ??
Hi:

I have this program that reads from an array to do calculations. The array are just t

Sql and php order list script problems
Hi im having a few problems with trying to get the coding right on a orders list ive done (or trying

Google Wave
So... has anyone used it yet? Is it any good?

http://wave.google.com/help/wave/about.html#vid

Amatuer requiring assistance
Beginner and amateur in need of assistance

My Site - (Spare Parts for Domestic Appliances)

first few characters only
hi, does anyone know how to use PHP to take the first few words of a text and limit them? i have see

PHP and MySQL on intranet?
Is it possible to use both these on an intranet network?

Javascript form submit and radio buttons?
When this form is submitted, it is automatically resubmitted using JS.

All my fields are carr

User registration and login
I don't know whether this is the correct forum, if not i apologise but am pretty desperate at the mo

Need understanding of this bit of code
Code: <?php
// WHERE clause filters
$arrSQLFilters = array();

//