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

Alterar a hora do servidor
Se alguém souber, ajude-me a adicionar 6 horas, obrigado
<tr>
&

help with insert
Hi there,

I am trying to insert some data into a database, but for some reason, it is not ins

updating a single value to multiple non consecutive rows
I need to update the same value to multiple non consecutive rows. I need to add an experation date t

Security Exception on pages using AJAX
I am getting the exception: attempted to perform an operation not allowed by the security policy on

Simple Question
I know this is a simple question, that if I knew what it was technically called i could probably loo

php multiple action on submit
I have a form which says:

<form enctype='multipart/form-data' method='post' action='pr

Could Someone Please Debug This?
I was wondering if someone could debug this script for me. I realize it's not the tidest script (and

Hardcopy printing is to wide
I want to make a hardcopy at runtime of my active form like this

Transferring session variables into MySQL
I am trying to transfer $_SESSION variables into MySQL. However there is an error in my MySQL statem

How to add an image/C++ OpenGL?
Hi,

I have been trying to look online for this and, so far, I haven't found anything usef