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

LSB (PHP 5.3) problem with static value!
hello,

i'm having a problem. static::$text variable gets lost at some point. can someone plea

Warning: Cannot modify header information - headers already sent by (output sta
Warning: Cannot modify header information - headers already sent by (output started at /home/praylif

Checking if a process is running (problems including psapi.dll i think...)
Ok, so all I'm trying to do is check if a program is running...

I've found out that I nee

Logic question
im wondering what's the best method to do the above list:

it is for alliance @ MMORPG game

Material xxx does not exist in plant xxx
Dear All,

I am working for a steel project which is repetitive manufacturing.

grouping within a foreach?
hello all,

I currently have a list of products spit out from my db via a foreach loop. Right

Help with email validation please...
Hi,
Please could you help.
I have a register.php login page where users register, the detail

This must be easy , pulling the last record of the day, every day, from a txt
I have a txt file logging weather data every minutes (so 1 record per minute). I want to extract the

IS this code correct
The reason i ask is everything underneath it appears to be alink as well, tis blimmin annoying

Can't shake the "Warning: include()" error
I've just uploaded my site to a new server and where I have PHP include tags in my HTML, the browser