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

Select Lists into MYSQL
Hello All, I am new to PHP @ 1 week. So borrowing code anywhere I can. I am making progress, but h

Problem in String replace program's output
Hi all,
I was trying to make a program which accepts a string and replaces it with another stri

Sql and php order list script problems
Hi im having a few problems with trying to get the coding right on a orders list ive done (or trying

how to load php class from another domain?
how to load php class from another domain?

Line break?
Hi, I'm new to the forum and new to php. I'm not sure if I'm using the correct terminology so here i

switch not getting value
what am i doing wrong?
i want to populate the country list according to the category
i want to

Storing the referrer in session... problems with tabs
Hello All

I am currently working on an ERP project based on the MVC methodology, when a user

php + mysql count consecutive data
I have a database of values and I want to work out how to display them if the values match a consecu

ASP.NET Validation Event Cycle
Hi,
I have asp button as follow:

GET * FROM _____ Except?
I have a site that is for stock photography.

This section of the code calls images to display

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