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

Consuming MII WebService in Java WebDynpro
Hello,

We are facing a strange situation...

We define a transaction in MII to

Email Form Syantax Issue 2
How to make this look FROM:"OUR TEAM" instead of FROM:abc@mail.com

$headers = "

RTF fomatting to email content
Im trying to sen an email with content is picked up from a rtf-file (file_get_contents('*.rtf'). Mai

Trouble verifying database password
Thankyou to everyone who responded to my last post (I can't find the posting, it has been buried). <

include
Hi I have this way of licensing my PHP application, and I want to know if you guys can answer some q

BB_Code error
I'm having a problem with a custom built function and keep getting this error:


Warning: M

How to read CSS message data
Hi,
I have a requirement here. When working as a Dev angel for multiple customers its really di

dropdown menu
Hello everbody,

I am php newbie.
I need to develop a program that once click the drop do

Timer control causing error
I recently decided to add a timer control to an existing page that uses AJAX on my site. As soon as

bit of help needed
Im about to sort out my registration page for my website by customising a "registration" s