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?

Did you know?Explore Trending and Topic pages for more stories like this.
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?
No comments posted yet

Your Answer:

Login to answer
51 Like 32 Dislike
Previous forums Next forums
Other forums

Using system() and bringing back the results
I am aware that you can use system() within PHP to execute system commands, but I was wondering if t

Looking for help on using joining mysql tables and php....
Does anyone have any good links to references on how to pull mysql data, through joining tables and

generating random codes
Hi guys n gals,

I have a requirement to generate 250,000 unique codes...

These codes a

square instead of number
Hello
I do not know why but this code seems to work fine only in my xampp local insallation but n

php email checker
I am having alot of trouble finding info on how to do these email things. I need to do the following

PHP Surveys
I really would like some advice.

If you have a client come to you asking for a survey to be d

ASP.NET 2.0 - Enter Key - Default Submit Button
Hi,One of the most annoying things in developing web pages is handling the "Enter key" for form subm

iterating through an array and escape each value independently.
I have a set up where the variable being escaped is an array and it needs to be iterated and escaped

making web pages for accounts
Hello, I would like to make pages for accounts on my website im making (its not a real website..im j

Help: calling function
Hi,
Is it possible to call a php function on page close?
If yes, could you explain how and whe

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash