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

I need some help with the IF command...
I have a large number of images in one section of my website with the .jpg format. I'm adding a bun

empty() error
Why does

Code: empty($USER_ID = $_SESSION["USER_ID"])
create this error...

How to ask a regex question?
Hi, I thought I'd share some of my insight after seeing too many bad questions that either get ignor

add to sql result
ok see rite now my sites hit counter is counted from the mysql visitor log i need to clear it aft

! = ''
In the following 'IF' statement if v_ompcat = PU for example then Oracle equates that 'IF' statement

Quick variable question
hey guys/gals,
im trying to write a php script and it works fine as i have it, but i need to set

j1inmis Ouput layout changes
Hi,

Can anybody tell how can j1inmis output layout can be changed so that vendor names ge

Polymorphism
Was wondering if someone could explain this a little better to me. I had always assumed that it had

form class help (oop php5)
Hidy Ho Neighbors,

I'm forcing myself to learn oop/classes for php5. It seems like a good id

How to secure my login data to my database?
Hi there,

It may be a stupid question but I don't know how to secure my login data to my data