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

PHP loop
Okay so I have several "articles" stored in a mysql database and am attempting to echo tho

double and single quotes in text fields acting up... help please
Single quotes, when entered into a text field, create an sql error upon Submit. It seems to create t

timed header image rotation
I have a joomla site and I was trying to setup a rotating image based on timing NOT just refreshing

.htpasswd Registration Form
Hi,
I wanted to make an htpasswd registration form.
I found this code on the internet but have

Shuffle Array
Hi,

I am writing a script for a game that needs players to randomly be assigned a target (ano

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,

Sessions Value Not Saved
Hi,

Im making a login form and im using this code:
Code: if($login=="true"){

private constructor
Hello,

Can we create a constructor as private? If yes, what is the use of it? If no, why can'

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

This section of the code calls images to display

[PHP HELP] Php order form.
Hello to everyone @ phpfreaks. Im new to this site and hope to learn lots of things here.

Fir

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