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

Problems with adding a link to one position in a 'foreach' loop, please help
Hello!

Iam pretty new to programming and I wanna create a table with users from an array. It

Find occurences of unicode characters in string
I need to prohibit filenames with everything but English characters and numbers but regexp and strin

New Search Engine problem
Hey everyone,

I have a ZIP Code Radius search engine already functional. it displays all of t

simplexml and xpath - Need some help
Hello,

I am trying to parse an xml which comes back from Amazon and I am trying to know how m

Keeping data in form
How can I keep whatever I write in the form?

Functions Not Loading Into Div
I had some help doing some of this but what I'm trying to do is get my functions to retrieve its val

adding 0 to numbers
Hey guys i need to create a 00001 number in a loop. Is there a better way of forcing a 5 digit numbe

Removing Title From database problem
Hi again ! i am having an issue with updating database. When i update any price of a title it remove

str_replace help
Hey there,

I'm a PHP newb, I'm having troubles with the str_replace function. I want to clean

how make 2 column in table with data tybe long row
hi every one

I want make in my table 2 column with data tybe long raw

how thi