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

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

Optimize Code
Just started getting into the use of cookies. The following code will redirect users to a set URL s

Get last modified date of web page
Hai All,

In php how can i get last modified date of a give web page . I have tried to g

Sending CC Info by email
I am a little bit less knowledgable in the security area as most developers and I know I have a lot

Coding question?
Hey guys, I have a quick question. If I want to make a way for people to pay for health in my game,

Generate PDF
Hi guys,

I would like to know if there is a way to generate pdf when clicking on a link. In f

function not returning the correct value
I have a program that needs to return a value from a function. I have an output statement inside the

Getting rid of quotes when printing data
Hi Guys, I use the filter_var FILTER_SANITIZE_STRING to filter the textarea input. The function esca

user administration
Dear @all,

what I have to do to set the user defaults for new users. At the moment I woul

Website Direction...
I recently used this code to try and make it so the page loads as http://www.domain.com/ when you ty

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