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

Inter Company -- Resources Related Billing (Services Industry)
Hello,

My company has a scenario where:
Company A bills Company C for INTER (cross

problems with script
I made a small script wich exchanges points in my website:


<?php
session_start

Question handling xml data
Hello,

I have sucessfull followed this tutorial
http://www.phpfreaks.com/tutorial/handlin

Sharing PHP Sessions Across Domains
I am in the process of writing a script to share a php session across various domains I have.
The

php global variable
how can we create global variable so we can use its value in any form.. Please give example to

PHP doesn't send my mail
Hi all, I found this and used it to send mail. Simple contact form with some required fields. The va

split string
Hi all

i have some names (imploded by comma):
Code: toronto,paris,madrid
Now, i would

OOP help
okay so i have a class im making it has everything setup i just need to randomize the 2 variables an

Using Windows message as a Handle
Hi,

I am writing one of my first multithreaded programs.

In one of the thread,

Help, Base64 encoding url and decoding server side.
Hello everyone, i have a website with videos and games and also provide an embed code which people c