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

Array becomes unset by itself?
Hi,

I have a bit of experience with PHP but not extensive. It seems I cannot store any items

login page does not execute a else statement
I've created a login page using sessions.
When an incorrect user name or password is entered then

question about header() security
is is safe to just use the header() function to redirect someone if they are, say, not logged in? or

Losing 'page' data
I have this code that allows me to update my database. But after updating, I lose the $_GET['page']

Connecion issue
Hi,

For some reason, I keep getting this error when trying to connect:

Warning: mysql_

foreach help.
Hello all,

First time I'm attempting to use a foreach statement and was just wondering if my

getting rid of quotes in strings
sick of trying to deal with them in multiple ways (entering in and taking from database, echoing, ec

preg_replace question
Hello!!

I hope someone can help me with preg_replace.

I load two tables from an extern

How to copy a part of a vector in a raw memory
Hi,

How can I copy a part of a vector into a memory:

1
2
3
4
5

Storing/displaying image urls in a database?
Hi
Basically I have the following scenario:
User chooses picture from list. Picture info is ad