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

Calander layout
Hi i know this sounds like a simple question but i cant find the answer to it anywhere i have added

wav to mp3 + goDaddy
I need to convert wav files to mp3s. From what I have found so far one way to do it is to have my PH

bind error during socket programming
i am kinda new to socket programming. wrote the below code for a server. but getting the bind error

How to show a complete textarea ??
I enter Client Case Notes notes in a textarea field on a PHP form. The field is 5 rows deep and 70 c

What are the two different files you download to update kernel?
What are the two different files you download to update kernel?

value not going in data base
hello friends....
i am having a working javascript....when i am selecting any

Server side $_SESSION
how does one keep the session completely server side. no cookies to the browser at all. i need this

Quick Question about echo value
Hey guys, I'm trying to get something to show differently in one of my scripts. I'm trying to make

How to set pass login name from htaccess to php
When the user logs into my members page via htaccess, I'd like to retain the username so that I can

Inserting 100x and 100y coordinates in mysql table - easy
Is there a way to insert this data into a mysql table named 'map' with the fields: 'x int 3' , 'y in

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